Greeting fellow Humans,
I'm trying to "comb merge" (if any thing as such) bunch of Excel files. There are 2 type of Excel workbook: A & B
Both has a column called : Location ID
These are the step I think the prog should do :
Promp user to select location of 2 file >> Read data from the user selected file >> Open pre-set Excel template paste item accordingly >> Save it!
Final Output: Same Location ID from both workbook in 1 sheet beside each other..
Possible? please guide me..newbie here..done my research Smile | :) **i can post picture of the files but i don't think you can on here
**Update: there are many pair of A&B files.Each pair of A & B files has different number of rows
**Here is how the interface looks like, just to gv an idea: http://www.imgplace.com/viewimg849/8800/45mergeinterface.jpg