Copy a particular column of all the Worksheets in a folder in a newworksheet
 

Hi

Please can anyone help me on below query:-
I have different workbooks in a folder. All workbooks are of the same
format column 1 is having unique identification of rows. Column 32
contain the update of the order (column 1 ) on a particular day.
Column 1 of recently added file contain all the orders . say column 1
of day 1 will have 10 entries, column 1 of last file will have all
these 10 columns plus new entries.

Now I need a macro which can club column 32 of all the files in a new
workbook, from column 2 onwards.
column 1 will be the same as column 1 of the recently added file.

Regards
sanjay

Copy a particular column of all the Worksheets in a folder in a ne
 

Hi,
Take a look to Ron's web

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


"sanju" wrote:

Hi

Please can anyone help me on below query:-
I have different workbooks in a folder. All workbooks are of the same
format column 1 is having unique identification of rows. Column 32
contain the update of the order (column 1 ) on a particular day.
Column 1 of recently added file contain all the orders . say column 1
of day 1 will have 10 entries, column 1 of last file will have all
these 10 columns plus new entries.

Now I need a macro which can club column 32 of all the files in a new
workbook, from column 2 onwards.
column 1 will be the same as column 1 of the recently added file.

Regards
sanjay
.