Recording a Macro to begin different cell number each time

zexcel2112

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

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
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

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

Watch MrExcel Video

Forum statistics

Threads
1,127,147
Messages
5,623,008
Members
415,946
Latest member
bellerom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top