mrmagoo321
New Member
- Joined
- Aug 9, 2010
- Messages
- 2
Hi all,
I am new to this forum but I have some good experience with excel.
I am working on a project that tracks data by date on various different worksheets (10 different sheets)
The final worksheet is used as a SUMMARY. Currently it is used to input any date and tally how many events took place that day. However, once this date is set, all of the other worksheets must be filtered manually to give an accurate summary.
I was wondering if there was a script or macro that could be used to filter all of the worksheets by date when a new date is set in the SUMMARY worksheet.
Please let me know if this question has already been answered in this forum, else any help would be appreciated.
Feel free to MSG me if you need some more specifics.
Thanks in advance
I am new to this forum but I have some good experience with excel.
I am working on a project that tracks data by date on various different worksheets (10 different sheets)
The final worksheet is used as a SUMMARY. Currently it is used to input any date and tally how many events took place that day. However, once this date is set, all of the other worksheets must be filtered manually to give an accurate summary.
I was wondering if there was a script or macro that could be used to filter all of the worksheets by date when a new date is set in the SUMMARY worksheet.
Please let me know if this question has already been answered in this forum, else any help would be appreciated.
Feel free to MSG me if you need some more specifics.
Thanks in advance