Copying cell formats

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

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

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

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

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

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

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