peter.abing
New member
- Joined
- Oct 24, 2012
- Messages
- 34
- Reaction score
- 0
- Points
- 0
Hi everyone,
I would like to ask for your help in Excel.
I have several sheets in a workbook. All sheet contains similar data (same number of columns and same column description). Each sheet represents different group of data (example, sheet1 may be for one month and sheet2 is for another month, or sheet1 is for one project manager and sheet2 is for another PM).
What I want is to consolidate the data into one sheet. Every time I enter a line in one sheet, that line will automatically be updated in the consolidation sheet on the next empty row. It would be similar to a database.
Is this even possible? How would you go about it?
Regards,
Peter
I would like to ask for your help in Excel.
I have several sheets in a workbook. All sheet contains similar data (same number of columns and same column description). Each sheet represents different group of data (example, sheet1 may be for one month and sheet2 is for another month, or sheet1 is for one project manager and sheet2 is for another PM).
What I want is to consolidate the data into one sheet. Every time I enter a line in one sheet, that line will automatically be updated in the consolidation sheet on the next empty row. It would be similar to a database.
Is this even possible? How would you go about it?
Regards,
Peter