Hello, the following macro goes into 4 workbooks and pastes the data into the current macro workbook cells A1, A2, A3, A4. I know how to manipulate whether the code starts at A2, A3, etc, by changing the "Cells (i+1,1)" to "Cells (i+2,1)", but my question is how do I manipulate the code to paste the data in A1, B1, C1, D1? Thanks!
Please Login or Register to view this content.
Increment the column instead of row like this >> Cells(1, i)
So, row 1 is fixed, and "i" the column increments with each loop.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thank you both - I appreciate it!
Please Login or Register to view this content.
Glad we could assist. Tx for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks