Need help with adding new data at bottom of listing without over riding checks a few rows later (macros)
retained text
I’m willing to pay $25 if someone can help me out. You have data from row 1 to row 100. You have a reconciliation from row 105 to row 110. You have 20 rows of new data you want to paste from row 101 to row 120. You want to: add 20 rows above row 105 and paste the data from row 101 onwards. How can you do this? The data is coming from a power query I ran in another sheet. I ran a formula in that sheet in a new column to identify new data and used a count formula to count if new to identify the number of rows of new data. Then I copied that output (in this case the output of the count would be 20). I went to the sheet where I want to paste my data. Went to A1, and moved using arrow keys and control to a column in row 105 with the reconciliation work. Moved a column left, pasted as value (20), let’s say in D105. Moved another column over to C105 and ran: Row()&”:”&(Row()+D105 to get: 105:125. Copied that, highlighted the entire row. Clicked the cell name at the top left, pasted as value, pressed enter, pressed esc to cancel the paste, and pressed ctrl+shift++ to add 20 rows. Then I used arrow keys to get to the bottom of my data, went to my other sheet, copied the data filtered for “new”, went back to the sheet I want to update, and paste as values. Stopped recording. When I ran it, it messed it up and pasted it like 20 rows under my last row of unupdated data. Is there a better way to do this? given how obsessed we are with these checks at the bottom of spreadsheets there’s no way other accountants haven’t crossed this bridge before.
document fetched 2026-09-22 00:18 · canonical https://reddit.com/r/Accounting/comments/1wmg6o0/need_help_with_adding_new_data_at_bottom_of