without knowing the layout of your data, my thought would be to use a pivot
table to get different views.
It is found under the data menu.
Debra Dalgleish has plenty of information at
http://www.contextures.com under tech tips.
"oakman" wrote:
Greetings,
I would like to thank people in this forum for all the help I have
received. I would also like to ask for more of that kind help. I have
a list on a sheet named €śSummary€ť. This list is for every day of the
month. On the column next to it I have a formula that brings up the
work €śConflict€ť next to the day depending on other criteria so this
word only appears next to the days that meet the criteria. I also have
another sheet named €śHourly View€ť with a template to format data in a
certain manner. I would like to create the €śHourly View€ť sheet for each
of the days in the month that have the work €śConflict€ť next to them. In
addition, if possible, I would like to rename each of the new tabs with
the day of month that it was created for. Thank you so much for any
help!
--
oakman
------------------------------------------------------------------------
oakman's Profile: http://www.excelforum.com/member.php...fo&userid=9172
View this thread: http://www.excelforum.com/showthread...hreadid=567011