Hi Gary,

Thanks for that, but I probably missed out the word "automatically".

Each time I reset the date on the summary page, the VLOOKUP copies all the
shift times automatically (as Excel does) to the summary page. What I need to
occur at the same time is the automatic update of the fill colour for each
cell. I accept that if I was manually copying the planner details to the
summary sheet, then paste with formats would be the option to use.

The other challenge I have is that these workbooks (there are four, 1 for
each location) are also updated by non-pc literate staff, so it needs to be
as simple to operate as possible.

Stu

"Gary L Brown" wrote:

> Try...
> Edit>Paste Special>Formats
> HTH,
> --
> Gary Brown
> gary_brown@ge_NOSPAM.com
> If this post was helpful, please click the ''''Yes'''' button next to
> ''''Was this Post Helpfull to you?".
>
>
> "Stu - Wast" wrote:
>
> > Hi,
> > I am working with large spreadsheets for staff rostering. The main planner
> > sheet holds info for each staff member acros the columns, and the dates they
> > are working down the rows. Each staff/date cell ahs a time value (the shift
> > start time) or a text value (Leave, sick, etc). For the non-shift times ,the
> > cells are highlighted manually.
> > I also have a summary sheet, which displays ony 4 weeks at a time, by using
> > the VLOOKUP formula to select the date's values ,based on a given date on the
> > summary page.
> >
> > What I also want to do is copy the cell fill colour from the planner sheet
> > to the summary sheet - any help would be appreciated.
> >
> > Stu