How to save next data entry in next target range
Closed
jen
-
Jun 28, 2016 at 10:06 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jun 29, 2016 at 12:04 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jun 29, 2016 at 12:04 AM
Hello,
I am running a macro using a command button that saves data from A3:AB3 to a7:AB7. however when I change the data from A3:AB3 and click save, it overwrites the data in A7:AB7.
what command should I use to save the new data to the next column of the sheet?
Thank you in advanced.
I am running a macro using a command button that saves data from A3:AB3 to a7:AB7. however when I change the data from A3:AB3 and click save, it overwrites the data in A7:AB7.
what command should I use to save the new data to the next column of the sheet?
Thank you in advanced.
Related:
- How to save next data entry in next target range
- Save as pdf office 2007 - Download - Other
- How to save ping command in notepad - Guide
- Gta san andreas how to lock on target pc - Guide
- Tmobile data check - Guide
- How to save voice message in messenger pc - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Jun 29, 2016 at 12:04 AM
Jun 29, 2016 at 12:04 AM
Hello Jen,
I assume that you would like the data to go into the next available row.
From what you say, the macro works but it would seem that you have hard-coded the destination range so the data always goes into A7:AB7 and overwrites the previous data.
Please upload a sample of your work book using dummy data to a free file sharing site such as DropBox, ge.tt or SpeedyShare then post the link to your file back here. Include your current macro.
We can then try to sort it out for you.
Cheerio,
vcoolio.
I assume that you would like the data to go into the next available row.
From what you say, the macro works but it would seem that you have hard-coded the destination range so the data always goes into A7:AB7 and overwrites the previous data.
Please upload a sample of your work book using dummy data to a free file sharing site such as DropBox, ge.tt or SpeedyShare then post the link to your file back here. Include your current macro.
We can then try to sort it out for you.
Cheerio,
vcoolio.
