Hey Guys,
I need help in the modifying the code below to reflect 2 things; 1) only to open worksheet two and not look thru all the worksheets in a given workbook.
And 2) to choose header from row A2: and on, not from A1. Because there are two headers A1 and A2 rows have headers, but only A2 row is the header. I want it to change it so it can only copy the header first and then copy the data starting from A3 row and on.
I'm not able to post the code here because I don't have any post yet. but the name of the Code is "Combine All Data From All Worksheets in All Workbooks in a Specific Directory"
Please reply ASAP. Thanks in advance.