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

Multiple SUM's in a column 15
Import multiple workbooks to current workbook in specified row number 0
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Post my named ranges in column A 10
Checking specific text string in excel files stored in a folder 4
Find string from column A in Range("B2:F7") list the header of that column/s 5
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Need Excel Macro to select an unknown, named table and convert it toa range 1

Top