File Merge

[melvinm]

Hi every1

I have a huge data base of quality assurance sheets. now my problem is I need to add on to this master data list , the data from other sheets which i get from branches all over the country(same format). at the moment I use cut/copy/paste.

is there any way of merging it other than this way.

any ideas would be helpful.

is there anything like merging in excel?


Thanks

 

[al_b_cnu]

Hi melvinm,

I think you'll need to use VBA for this, something not too dissimilar to the solution I posted for this thread:
http://www.mrexcel.com/board2/viewtopic.php?t=181196