RE: Copying cell formats

Tech-Archive recommends: Fix windows errors by optimizing your registry

Try...
Edit>Paste Special>Formats
HTH,
--
Gary Brown
gary_brown@xxxxxxxxxxxxx
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
> *** 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 ***, 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 ***
> to the summary *** - any help would be appreciated.
>
> Stu
.

Quantcast