In this case row 8.You have a macro to make adjustments to the first sheet. But for Sheet 2 to continue to look for data in the original row. Klocksbass wrote:What I trying to do is have the data from the next row down to move up to the row that was deleted, which it does. Thanks for your input and greatly appreciated help and suggestions. What I trying to do is have the data from the next row down to move up to the row that was deleted, which it does. =IF('Sheet 1'.$B$#REF!="" "" 'Sheet 1'.$B$#REF!) because the cell was looking for data in a particular row that no longer exists because that row was deleted. Once the row is deleted however the code in Sheet 2 will changed to the following. Sheet 1 row 8 has a transaction with data throughout the row. Sheet 2 has a cell with the following code. When Paid transactions are needing to be removed then Matareuz’s code works perfectly, however the cells with formulas originally referencing the now deleted row(s) formulas are now showing #REF! errors.įor example.
Other wise it remains the number 1 or is blank. When a transaction is PAID in full the first cell of that row is given the number 2. The second sheet shows the data in a desired format with the use of merged cells and so forth. The second transaction data resides in Row 4 & so on.
So, all data from a transaction is in Row 3, for instance. Sheet 1 has all the data listed in rows per transaction. The Spreadsheet in question has two sheets. There is one additional issue I would like some help on that may require me to rethink how I am going about things for the end results I’m looking for. The code submitted by Matareuz works perfectly. I should have mentioned that the use of filters doesn’t work in this particular situation as the spreadsheet will be used by a co-worker that barely knows how to use a spreadsheet and would be confused by the many steps needed to reach the desired goal. Thank you Villeroy & Matareuz for your replies.
0 kommentar(er)
