- Registration date
- Thursday July 24, 2014
- Last seen
- May 7, 2021
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.