-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
macro beginner - no luck
- Thread starter glpark
- Start date
WillR
Well-known Member
- Joined
- Feb 18, 2002
- Messages
- 1,143
welcome to the board.....
surely you're not trying to paste a column from each of the workbooks into a row of a fresh workbook?
Are the names of the workbooks fixed (i.e. they don't change)??
Try to be a bit more specific about exactly what it is you are trying to do. Sure someone here will then be able to have a crack at helping you.
surely you're not trying to paste a column from each of the workbooks into a row of a fresh workbook?
Are the names of the workbooks fixed (i.e. they don't change)??
Try to be a bit more specific about exactly what it is you are trying to do. Sure someone here will then be able to have a crack at helping you.
Upvote
0
DonkeyOte
MrExcel MVP
- Joined
- Sep 6, 2002
- Messages
- 9,124
In addition to Will's comments - if you added all the data together into one column are you likely to exceed 65556 rows?
What you're asking to do is fairly straightforward to code BUT it's efficiency will be largely dependent upon the volume of data we're talking about...(though I guess it would still be preferable to doing it manually!).
Another option would be to import your Excel data into Access and then return all the data to one book using SQL (again pretty straightforward to code I think).
Good luck!!!
Awaiting next instructions...
What you're asking to do is fairly straightforward to code BUT it's efficiency will be largely dependent upon the volume of data we're talking about...(though I guess it would still be preferable to doing it manually!).
Another option would be to import your Excel data into Access and then return all the data to one book using SQL (again pretty straightforward to code I think).
Good luck!!!
Awaiting next instructions...
Upvote
0
Similar threads
- Question
