Consolidate the files into consolidated worksheet

[Tharabai]

Hi,

I need to consolidate the files to the consolidated sheet. Data in the files started from row # 6 and the columns will be till column R. The data in the consolidated file needs to be filled after the last used row.

Also, excluding the header the data to be copied and paste it in the consolidated sheet.

The user has to select the file to be consolidated.

 

[Nebu]

Hi:

Go trough the following thread, this will do exactly what you are looking for, you will have to tweak the code to suit your needs.

http://forum.chandoo.org/threads/vba-pull-purchases.24604/#post-153271

Thanks