Hi, I am trying to get excel to copy cells C31 TO C39 & paste them into a different specified excel spreadsheet (The same on each time) but paste them in the next row down, in order to not overwrite each other. I would like to create an excel sheet that resembles a database.

Is this possible?


The excel file location to be copy & pasted into is C:\Users\chris\OneDrive\Desktop\Blank Cost Sheets & it's named "pricing 2020" & Ideally need it pasting from A1 TO I1 if possible

Would anyone be able to help create VBA to paste it at all?

Thank you