Combine 2 worksheets into an existing tab with browsing for files

[Webbers]

Okay, I am very new to VBA, and I have managed to teach myself a little with the help of this forum, but I am not sure how to adapt a currently functional script to my current needs.

The script below is a working script I use, I thought I could adapt it, as my needs are similar, but I am just plain stuck and don't know how to approach this issue.

Situation: the "Summary" worksheet is in a file that changes name and path each time it is used. The 2 "source data" files also fall under this circumstance. I know the path will change, since I am creating this for someone else, I am unsure if I can control the file names, but if I have a say in it, they will be named "pma1" and "pma2". Neither worksheet will have a specific number of rows of data, they will both be completely random. These reports are both pulled from Cognos and saved as Excel files. Now when the two files are being combined, on the 2nd file (PMA2), row 1 must be excluded, as it contains the same header information that will be listed on "PMA1". Oh, also, the "Summary" tab where the data will be combined to will be a blank worksheet until this macro is used, and will always be open when the macro to combine the 2 PMA files is run.

Can the code below be revised to meet my needs or is it easier to just scrap it completely and start from scratch?

Please Login or Register  to view this content.

[arlu1201]

Isnt this the same request as http://www.excelforum.com/excel-prog...-workbook.html which was solved?

[Webbers]

Actually no. This one requires taking 2 reports and combining them into one. The other one was a simple copy and paste from one source to another.

[Webbers]

nope, note the same request. I will figure it out; marking as solved.