yichuansancun
Board Regular
- Joined
- Feb 7, 2011
- Messages
- 123
Hello -
I have a workbook that have multiple sheets. The sheets have the same data structure. How do I combine them into one without doing copy and paste? I tried using consolidate, but consolidate does aggregate on the values. In my case, I don't need to do any aggregation. It is all text. I simple just want all the data to be one the same sheet.
Thanks,
Perri
I have a workbook that have multiple sheets. The sheets have the same data structure. How do I combine them into one without doing copy and paste? I tried using consolidate, but consolidate does aggregate on the values. In my case, I don't need to do any aggregation. It is all text. I simple just want all the data to be one the same sheet.
Thanks,
Perri