Recording a Macro to begin different cell number each time

[zexcel2112]

hi,
I have a large CSV file with all my Shopify products. And because I have a second-hand clothing store I am constantly adding new items. To do this I use an existing excel sheet that I add extra lines into. It saves me time since most of the info is auto filled. However, there are cell that I have to copy down always , which never change, for example : Size, Brand, etc. It kind of gets annoying to have to drag stuff down a million times and Copy Down. I want to record a macro that will do this for me. But I see macros if recroded to begin in F39 for example will always start in F39 when run next time. Is there a way to command to just copy down for example the last filled cell in Column F down 50 cells? And so on....Column G down 50, etc

 

[mole999]

its very possible to identify the overall last row (where your new data has ended at), and also measure the last row where you last left off, then teach the macro copy down from your end point to the new end. I'm just not too sure about macros in an excel CSV file

 

[zexcel2112]

its very possible to identify the overall last row (where your new data has ended at), and also measure the last row where you last left off, then teach the macro copy down from your end point to the new end. I'm just not too sure about macros in an excel CSV file

thank you,
I should correct myself. It's not CSV. Its a macro enabled workbook . .xslm