add data from other sheets within a period (week)

**ionutz_nek** · 12-21-2009, 06:04 AM

hello
i have a workbook which contains 31 sheets, one for each day, and Total sheet.
i want to create results (add values from cells from different sheets) for a given week (or period of days), which the user inputs.
for example week from 21.12 to 27.12. so this selects sheets from 21th to 27th sheet

i attached an example file containing just 3 days and the total
could you please help me with it?
Thank you!

**royUK** · 12-21-2009, 06:28 AM

Why have daily sheets. Excel works best if allthe data is on one sheet, then you can use PivotTables, AutoFilter etc

**ionutz_nek** · 12-21-2009, 07:07 AM

i thought about that, but this way is easier for the user, altough it is not an optimal solution.

anyone, some ideea?

**royUK** · 12-21-2009, 07:12 AM

You are just making hard work by ignoring Excel's built in features

**ionutz_nek** · 12-22-2009, 03:31 AM

okey, forget about multiple sheets

now, how can i select and add cells within a range given by the user.
the user should press a button, and dialog box should open where it inputs the start and end date for the period.