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

S

sanju

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
 

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

conditional copy of column to another column of same worksheet 0
populate a combobox based on unique values in another workbook 16
Run macro on all files in a specific folder 3
Find string from column A in Range("B2:F7") list the header of that column/s 5
Finding and Replacing Data in a Header Row 0
I'm trying to do a "count" function at the end of a dynamic pivot table 0
Compare same data of column in two workbooks 1
Adding daily updates to other master sheets 0

Top