VBA_Hunter
New Member
- Joined
- Jan 3, 2018
- Messages
- 1
I have to go through excel files with multiple tables within one sheet, one after another, and copy and paste the name and unique ID of the table then paste, autofill to the side of it.
To lay it out more clearly, this is what I do manually. Copy the name and id of the first table in A3 and B3, then paste it into I5, and autofill down to I34. Then, repeat the process for the next table starting with the name and id in row 36 and pasting and autofill into I38 with same range dimensions as previous table. And repeat for the rest of the tables having the same dimensions until I get to the end.
How can I do it to automate this process?
To lay it out more clearly, this is what I do manually. Copy the name and id of the first table in A3 and B3, then paste it into I5, and autofill down to I34. Then, repeat the process for the next table starting with the name and id in row 36 and pasting and autofill into I38 with same range dimensions as previous table. And repeat for the rest of the tables having the same dimensions until I get to the end.
How can I do it to automate this process?
