NewExcelBoy
New Member
- Joined
- Jan 6, 2014
- Messages
- 17
Hello,
I want to extra the data from a spreadsheet report that has header, grouping cells.
Extracting the data from the default excel sheet where all the data stay nice on each columns are easy but what I am talking about is the spreadsheet that already been format here and there. So some data in column B5 to K5. Some of the data are in cell P2 and R1 and so on.
What I want to do is to extra those data to a new sheet so the data can be used easily in the accounting department.
Thank you
I want to extra the data from a spreadsheet report that has header, grouping cells.
Extracting the data from the default excel sheet where all the data stay nice on each columns are easy but what I am talking about is the spreadsheet that already been format here and there. So some data in column B5 to K5. Some of the data are in cell P2 and R1 and so on.
What I want to do is to extra those data to a new sheet so the data can be used easily in the accounting department.
Thank you