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