BIGTONE559
Active Member
- Joined
- Apr 20, 2011
- Messages
- 336
Greetings,
Need help creating a summary page by date. I have 17 sheets in a workbook however, 12 (Sheets 2-13) of them have data that needs to be summarized. Sheet 1 is the summary page.
On the Sheets 2-13 "J1".value is the date
Range("L10:L45") has numbers that need to be totaled based off criteria in Range("J10:J45").
For Example:
If L10=10
and J10=lbs
J1=07-20-11
or
L11=10
J10=Oz(s)
J1=07-21-11
this would be added to the Summary Page. The Dates would normally be within a 7 day period. However, some pages may have the same dates. The summary will be grouped by Values in J10. I hope this info helps.
Need help creating a summary page by date. I have 17 sheets in a workbook however, 12 (Sheets 2-13) of them have data that needs to be summarized. Sheet 1 is the summary page.
On the Sheets 2-13 "J1".value is the date
Range("L10:L45") has numbers that need to be totaled based off criteria in Range("J10:J45").
For Example:
If L10=10
and J10=lbs
J1=07-20-11
or
L11=10
J10=Oz(s)
J1=07-21-11
this would be added to the Summary Page. The Dates would normally be within a 7 day period. However, some pages may have the same dates. The summary will be grouped by Values in J10. I hope this info helps.
