I am working on a spreadsheet in Microsoft excel 2010. In the spreadsheet I have 3 worksheets. These are known as:
- 1st
- 2nd
- Cases
Now in the 1st and 2nd Worksheets, there is a table at the bottom which contains case details. In the Cases worksheet there is a case table as well but it's empty. What I want to do is the data from both 1st and 2nd Worksheet be automatically inserted in the Cases worksheet table.
How can this be achieved? I have tried consolidation by category by clicking on "Consolidate, selecting the relvant lables and data from the 1st and 2nd worksheet, and added them and clicked ok but it gives me message saying no data was consolidated.
Here is a link to the spreadsheet which can be downloaded:
Can you give me any suggestions on this or can somebody try and apply my spreadsheet onto an excel document and see if they can get it working?
P.S I know the 2nd Worksheet has blank data in its Case summary table, but this table can consist some data in the future.
Thank You