This may be a duplicate but I submitted it earlier and it didn't appear in the forum so I apologize if this appears twice.
I have a workbook with multiple worksheets. I'm trying to combine them all into one. They are all the same structure - same columns. No matter what I try this doesn't appear to work. I get a blank worksheet as a result. I've tried just doing two workbooks with two worksheets and get nothing. I've tried just two worksheets in same workbook and still nothing.
Not sure how to proceed. Any tips or help would be appreciated.
I have 35 worksheets to combine and this would save me a ton of time.
I have a workbook with multiple worksheets. I'm trying to combine them all into one. They are all the same structure - same columns. No matter what I try this doesn't appear to work. I get a blank worksheet as a result. I've tried just doing two workbooks with two worksheets and get nothing. I've tried just two worksheets in same workbook and still nothing.
Not sure how to proceed. Any tips or help would be appreciated.
I have 35 worksheets to combine and this would save me a ton of time.