macro beginner - no luck

glpark

New Member
Joined
Nov 7, 2002
Messages
5
I need to open about 450 workbooks, copy a column from each and paste it on the next free row of another workbook.
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

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. :)
 

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
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...
 

Forum statistics

Threads
1,143,709
Messages
5,720,389
Members
422,282
Latest member
psunith

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top