knighcloud
New Member
- Joined
- Jul 20, 2010
- Messages
- 13
I have three workbooks, each workbook contains a total of 105 sheets. Only 5 has a different format. The rest of the sheets are the same. What I'm hoping to do is to copy and/or merge the data from all sheets into one sheet in a separate workbook. Since all sheets have the same format, I would like to copy the header from the first sheet only and the rest would just be data. Each worksheet name starts with "Plot". Also, if the next row in the worksheet is blank, then proceed to next sheet to copy data and so on. I've tried several macro already, but since I'm a beginner in VB, I was not able to customize it to suit my need. Any suggestions? Thank you.
https://docs.google.com/leaf?id=0B2AH1L7bXPyhMGE5ZDdhMjYtZTY2ZC00ZWZjLWE3NGMtN2NlMzNjNTRhMThk&hl=en
https://docs.google.com/leaf?id=0B2AH1L7bXPyhMGE5ZDdhMjYtZTY2ZC00ZWZjLWE3NGMtN2NlMzNjNTRhMThk&hl=en