on going data file

Copper Contributor

I have a data file that needs a row added to it every year for the following year. Most of the fields just need to be copied down. I can't just copy it down normally because it will delete the data that's beneath it. I also want to avoid just copying each individual row and pasting it because it is a huge file.

 

For example:

rows 1-3 contains data X

rows 4-5 contains data Y

rows 6-10 contains data Z

I need to add a row for 2020 to each data X, Y, and Z. Is there a better way to do this than just individually copying and inserting rows?

0 Replies