jkf,

I would suggest that you use a single sheet, with an extra column for the date, and learn to use
autofilters.

HTH,
Bernie
MS Excel MVP


"jkf" wrote in message ...
hi,,first off fairly new to this so be gently

i need a sheet for each day of the month,and at the moment i am having to
make say 31 sheets for october and then renaming sheet 1 to 01.10.05,,sheet
2 to 02.10.05 etc. is there an easier way or am i stuck.

tia
jkf