Hi
I have tried searching but can't seem to find the right code for this. Thank you in advance for the help!
- I want to combine just column A (there are other data in other columns not included in the attached sample xls) from multiple worksheets (sheet 1, sheet 2, and sheet 3) into one worksheet (Combined) in the order of the worksheets.
- There are other "working" worksheets but I am not combining data from those. I can move them to the back if that helps and just combine the first few worksheets in that order.
- And the "Combined" worksheet has to be constantly updated so I am thinking data on "Combined" need to be cleared first?
- I also want to write the resulting "Combined" tab to a DAT file but I think I can find a code for that pretty quickly.
Please help!
Glenn
Bookmarks