Linking data within several Workbooks

L

leerem

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing Data in Closed Workbooks 4
Multiple Workbooks using same macro 4
Data keeps getting overwritten by macro 5
Linking Groups of cells between workbooks 4
How do I summarise data from several workbooks? 4
Formula within filename link 2
linking many workbooks 6
summarizing data from various workbooks 3

Top