Hello All,
We're using excel spreadsheet to maintain our time log and to log other business data.
We've a checklist, in that there are two work sheet - 1. Summary & 2. Checklist.
We enter our time and volume in worksheet 2. Checklist, and using formulas we got the consolidated data per person and activity in "Summary" work sheet.
These sheet are prepared on daily basis. I want to consolidate "Summary" worksheet data.
Could you please assist me how to consolidate data from specific cell range into one worksheet?
I'm not super expert in excel. Knows a bit and trying to learn advance level. thanks for your support.
Regards,
MK
We're using excel spreadsheet to maintain our time log and to log other business data.
We've a checklist, in that there are two work sheet - 1. Summary & 2. Checklist.
We enter our time and volume in worksheet 2. Checklist, and using formulas we got the consolidated data per person and activity in "Summary" work sheet.
These sheet are prepared on daily basis. I want to consolidate "Summary" worksheet data.
Could you please assist me how to consolidate data from specific cell range into one worksheet?
I'm not super expert in excel. Knows a bit and trying to learn advance level. thanks for your support.
Regards,
MK
