MrExcel Publishing
Your One Stop for Excel Tips & Solutions

excell macro


Posted by oded on June 17, 2001 2:48 AM

i have 3000 excell sheets with 10 collums each,
i would like to generate a new excell sheet that will have only one collum from each of the latter sheets,
(cut $ paset is too much work !!)
how to i creat a macro to automaticly to that ??

thnks
oded


Posted by Damon Ostrander on June 17, 2001 7:13 PM

Hi Obed,

Unfortunately, Excel worksheets can only handle 255 columns, so you would not be able to take one column from each of 3000 (or even 300) worksheets and copy them to a single worksheet. Writing a macro that copies the columns to a worksheet and starts another when that one gets filled would be fairly simple, but is that what you want to do?

Damon