Are you familiar with the Autofilter. Select A1 then do
Data=Filter=Autofilter
The user can then use the dropdown arrows to select the Month and day and
any rows with that month and day will be visible - other rows will be
hidden.
--
Regards,
Tom Ogilvy
dmorri254 wrote in message
...
Hi,
I am working on a report that will reflect changes during a month. For
example, the first row will say Month, Day, Total x, Total y, Total z,
the last row will be the sum of all totals.
Okay so what I would like is for the user to be able to the choose the
month and day, lets say Jan then choose lets say the day is 01/05 ...I
want them to see the data entered for that day reflected in that
row....how can I do this without creating a validation sheet with all
the months, days, etc...can I program this using month, day and range
functions?
What would be the best approach..
Thank you for your assistance.
David
---
Message posted from http://www.ExcelForum.com/