Collating data from workbooks

[kamlesh_Bhawsar]

can you please help me with a macro?

I need a macro for collating the data from n workbooks (from 1st sheet only) to an existing workbook in single sheet.

please help.

Thanks
Kamlesh.

[arlu1201]

Do all the workbooks have the same headers?

Are they all saved in 1 folder?

Since you want the data to be populated in an existing workbook, do you want the data already present to be deleted and then fresh data collated? Or should the data be entered in the next available row?

[kamlesh_Bhawsar]

all WB have same headers, saved in single folder.

need to delete old data and populate new.
need to pull data from A14 to BAn (*last 11 rows of no need)
to be pasted from column Dn to BDn
Sort the data on column K.

[arlu1201]

You mean data from A14 to BA (last row minus 11 rows) to be copied to the next available row in column D of the summary file?

[kamlesh_Bhawsar]

yes, you r right.

[kamlesh_Bhawsar]

one more thing, these files are downloaded from net, and giving an error before opening Error before opening the file.jpg need to click on Yes to open the file.

If this is a lengthy task, you can gimme macro to collate data from all open files. Thank you!

[arlu1201]

The macro can disable those alerts for you. Its good you mentioned about it.

[arlu1201]

Try this code

Please Login or Register  to view this content.

Change the bold section to match your system.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button

[kamlesh_Bhawsar]

Solved... Thank you!

[vgothe]

Hi,

In the above code, there is a specific range which is mentioned earlier. If i have a data range which is not fixed, how do i copy it. Currently i am selecting range using Ctrl + Shift + End. Can you suggest an updated code which will select the whole range in the sheet and past it in the worksheet. Thank you very much.

VG

[arlu1201]

Vgothe,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.