PDA

View Full Version : Copy data to Master file from Different Sheets



xls
05-22-2012, 03:44 AM
Hi I have master file in which i have to copy data from a particular folder or existing open sheet (if any)

Macro to copy data from sheets to master file an append data below existing data sequentiall in same order of header1.

There is no surety of header in a particular raw, either it will be in second raw or third raw.

All sheet data to be extracted from a particulat sheet named "InputSheet" from a different file.

Master sheet has limited coloumn at present 10 coloumn & same may get increase to 12.

Input sheet may not have all colomns. If coloumn is not there then data to be input as Zero.

Sequence is like this:
Master sheet has 10 headers:

1-If there is any opened workbook then macro to search for Header 1 in "Input Sheet" and copy all data below header 1 & paste in to master sheet below header 1.

2-Then macro to search for Header 2 in "Input Sheet" and copy all data below header 1 & paste in to master sheet below header 2 and so on...

No. of raws to be selected for all headers to be remained fix for all headers.

If header 1 has 50 continuous raw then for all remaining headers only continuous 50 raws to be selected. If any blank raw is there then same to be replaced with zero.

If no file is open then macro to ask for path from folder which contains files to be processed.

Eaxample file of master data is attached here for reference.

Thank you in advance for support.

xls
05-24-2012, 10:07 AM
Any doubts??