Helo Excel experts, I need your assistance;
I need to copy the columns of each workbook into a separate workbook to
anaylise its data, How can i do this eliminating any blank cells.
Eg. there are five workbooks Data 1.xls - Data 5.xls all the data is
identically located in columns 'A' to 'K'. I need to copy the values of each
column {Data 1.xls to Data 5.xls and append the data in the same layout in
another workbook analyse.xls, thereby making a long column 'A'; long column
'B' etc without any breaks in the data and eliminating any blank cells at the
same time

Your assistance would be much appreciated

Check out Ron de Bruin's site for code.

http://www.rondebruin.nl/tips.htm

Browse through the Copy/Paste/Merge section.


Gord Dibben MS Excel MVP

On Sun, 3 Aug 2008 23:02:01 -0700, leerem
wrote:

Helo Excel experts, I need your assistance;
I need to copy the columns of each workbook into a separate workbook to
anaylise its data, How can i do this eliminating any blank cells.
Eg. there are five workbooks Data 1.xls - Data 5.xls all the data is
identically located in columns 'A' to 'K'. I need to copy the values of each
column {Data 1.xls to Data 5.xls and append the data in the same layout in
another workbook analyse.xls, thereby making a long column 'A'; long column
'B' etc without any breaks in the data and eliminating any blank cells at the
same time

Your assistance would be much appreciated