zexcel2112
New Member
- Joined
- Apr 5, 2020
- Messages
- 6
- Office Version
- 2011
- Platform
- MacOS
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
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