# Need help with adding new data at bottom of listing without over riding checks a few rows later (macros) — retained record

> Retained reddit record from reddit:Accounting.

Canonical: https://highsignal.app/data/records/085a9f32ec1cd120

[← sources](https://highsignal.app/data)


source: [reddit](https://highsignal.app/data/reddit) (reddit:Accounting)  published 2026-09-21 15:34 ingested 2026-09-22 02:35

[original source ↗](https://www.reddit.com/r/Accounting/comments/1wmg6o0/need_help_with_adding_new_data_at_bottom_of/)

## 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
