Please help, I have a 365 day schedule and want sheet tab 1 to show the whole
thing then sheet tab 2 to show Q1 Jan - March.
So any data changed on sheet one the full year will be reflected in sheets 2
- 5 labelled Q1 - Q4?
Im sure its easy but i have really searched.
Please help me.
Thanks already,
Kev.

if the format is the same for the quarter sheets as it is for the master sheet
on each quarters sheet, enter an = in cell A1 (Or A2) and without hitting
enter go to the mater sheet and select the top left cell for that quarter. on
the quarter sheet then, copy the first cell to as many other cells as needed.

"Kev" wrote:

Please help, I have a 365 day schedule and want sheet tab 1 to show the whole
thing then sheet tab 2 to show Q1 Jan - March.
So any data changed on sheet one the full year will be reflected in sheets 2
- 5 labelled Q1 - Q4?
Im sure its easy but i have really searched.
Please help me.
Thanks already,
Kev.

On May 1, 5:11 pm, Kev wrote:
Please help, I have a 365 day schedule and want sheet tab 1 to show the whole thing then sheet tab 2 to show Q1 Jan - March.
So any data changed on sheet one the full year will be reflected in sheets 2 - 5 labelled Q1 - Q4?

Do you just need this so that they can be viewed / printed separately?
If so, play about with View....Custom Views on the menu.
Hide everything except Q1 information, then add a view, give it a name
"Q1".
Unhide everything, then hide everything except Q2 information, then
add another view, give it a name "Q2".
If you want to see Q1 layout, got to View.....Custom Views...click on
the one you want, and click Show.

If you need five separate worksheets?
Simplest way I know is to link every cell in the Q1 worksheet into the
correct place on the front worksheet (which I shall call "Summary").
e.g, in the Q1 worksheet, there would be a formula in cell A2:
=Summary!A2

When you update cell A2 in the Summary worksheet, the Q1 worksheet
will automatically update.

Be careful not to let anyone type anything directly into the Q1
worksheet - the update works in one direction only.

HTH

Andrew

Thanks so much Loudfish, Ireally appreciate your help.
It it the seperate sheet option I am trying to implement so that my boss has
easy access to quartery views of the yearly schedule.
Your solution works great on many levels but does not seem to transfer
colour, patterns or comments to Q1 from 'Summary'.
Most of the data on 'Summary is represented in colour/patterns and there are
many comments and hyperlinks.
Can i beg you to get back to me if there is a solution???
Kev

"loudfish" wrote:

On May 1, 5:11 pm, Kev wrote:
Please help, I have a 365 day schedule and want sheet tab 1 to show the whole thing then sheet tab 2 to show Q1 Jan - March.
So any data changed on sheet one the full year will be reflected in sheets 2 - 5 labelled Q1 - Q4?

Do you just need this so that they can be viewed / printed separately?
If so, play about with View....Custom Views on the menu.
Hide everything except Q1 information, then add a view, give it a name
"Q1".
Unhide everything, then hide everything except Q2 information, then
add another view, give it a name "Q2".
If you want to see Q1 layout, got to View.....Custom Views...click on
the one you want, and click Show.

If you need five separate worksheets?
Simplest way I know is to link every cell in the Q1 worksheet into the
correct place on the front worksheet (which I shall call "Summary").
e.g, in the Q1 worksheet, there would be a formula in cell A2:
=Summary!A2

When you update cell A2 in the Summary worksheet, the Q1 worksheet
will automatically update.

Be careful not to let anyone type anything directly into the Q1
worksheet - the update works in one direction only.

HTH

Andrew

As the layout is identical in all sheets, you can do this - highlight
all the Q1 data on the summary sheet and click <copy. Then select the
Q1 sheet in cell A1 and Edit | Paste Special | Formats (check) | OK.
This will copy the forrmats (only) to the Q1 sheet. Repeat for the
other quarters.

If the formats are changed on the summary sheet this will not be
reflected on the other sheets, but you can easily re-apply the
procedure.

Hope this helps.

Pete


On May 3, 12:14 pm, Kev wrote:
Thanks so much Loudfish, Ireally appreciate your help.
It it the seperate sheet option I am trying to implement so that my boss has
easy access to quartery views of the yearly schedule.
Your solution works great on many levels but does not seem to transfer
colour, patterns or comments to Q1 from 'Summary'.
Most of the data on 'Summary is represented in colour/patterns and there are
many comments and hyperlinks.
Can i beg you to get back to me if there is a solution???
Kev



"loudfish" wrote:
On May 1, 5:11 pm, Kev wrote:
Please help, I have a 365 day schedule and want sheet tab 1 to show the whole thing then sheet tab 2 to show Q1 Jan - March.
So any data changed on sheet one the full year will be reflected in sheets 2 - 5 labelled Q1 - Q4?

Do you just need this so that they can be viewed / printed separately?
If so, play about with View....Custom Views on the menu.
Hide everything except Q1 information, then add a view, give it a name
"Q1".
Unhide everything, then hide everything except Q2 information, then
add another view, give it a name "Q2".
If you want to see Q1 layout, got to View.....Custom Views...click on
the one you want, and click Show.

If you need five separate worksheets?
Simplest way I know is to link every cell in the Q1 worksheet into the
correct place on the front worksheet (which I shall call "Summary").
e.g, in the Q1 worksheet, there would be a formula in cell A2:
=Summary!A2

When you update cell A2 in the Summary worksheet, the Q1 worksheet
will automatically update.

Be careful not to let anyone type anything directly into the Q1
worksheet - the update works in one direction only.

HTH

Andrew- Hide quoted text -

- Show quoted text -

"Pete_UK" wrote:

As the layout is identical in all sheets, you can do this - highlight
all the Q1 data on the summary sheet and click <copy. Then select the
Q1 sheet in cell A1 and Edit | Paste Special | Formats (check) | OK.
This will copy the forrmats (only) to the Q1 sheet. Repeat for the
other quarters.


Sounds cool Pete and thanks,
but
Will this action continue to update the data in Q1 as it is entered into
summery (or vice versa?) or will i have to copy across the colours/Text every
time data is entered?

If the formats are changed on the summary sheet this will not be
reflected on the other sheets, but you can easily re-apply the
procedure.

Hope this helps.

Pete


On May 3, 12:14 pm, Kev wrote:
Thanks so much Loudfish, Ireally appreciate your help.
It it the seperate sheet option I am trying to implement so that my boss has
easy access to quartery views of the yearly schedule.
Your solution works great on many levels but does not seem to transfer
colour, patterns or comments to Q1 from 'Summary'.
Most of the data on 'Summary is represented in colour/patterns and there are
many comments and hyperlinks.
Can i beg you to get back to me if there is a solution???
Kev



"loudfish" wrote:
On May 1, 5:11 pm, Kev wrote:
Please help, I have a 365 day schedule and want sheet tab 1 to show the whole thing then sheet tab 2 to show Q1 Jan - March.
So any data changed on sheet one the full year will be reflected in sheets 2 - 5 labelled Q1 - Q4?

Do you just need this so that they can be viewed / printed separately?
If so, play about with View....Custom Views on the menu.
Hide everything except Q1 information, then add a view, give it a name
"Q1".
Unhide everything, then hide everything except Q2 information, then
add another view, give it a name "Q2".
If you want to see Q1 layout, got to View.....Custom Views...click on
the one you want, and click Show.

If you need five separate worksheets?
Simplest way I know is to link every cell in the Q1 worksheet into the
correct place on the front worksheet (which I shall call "Summary").
e.g, in the Q1 worksheet, there would be a formula in cell A2:
=Summary!A2

When you update cell A2 in the Summary worksheet, the Q1 worksheet
will automatically update.

Be careful not to let anyone type anything directly into the Q1
worksheet - the update works in one direction only.

HTH

Andrew- Hide quoted text -

- Show quoted text -

The procedure will copy formats (colours, fonts, conditional formats
etc) as a one-off, but the formulae you have been given earlier will
ensure that the data values reflect any changes to the values in the
summary sheet. It's only if you change the colours manually in the
summary sheet that you will have to re-apply the procedure.

Hope this helps.

Pete


On May 3, 1:21 pm, Kev wrote:
"Pete_UK" wrote:
As the layout is identical in all sheets, you can do this - highlight
all the Q1 data on the summary sheet and click <copy. Then select the
Q1 sheet in cell A1 and Edit | Paste Special | Formats (check) | OK.
This will copy the forrmats (only) to the Q1 sheet. Repeat for the
other quarters.

Sounds cool Pete and thanks,
but
Will this action continue to update the data in Q1 as it is entered into
summery (or vice versa?) or will i have to copy across the colours/Text every
time data is entered?



If the formats are changed on the summary sheet this will not be
reflected on the other sheets, but you can easily re-apply the
procedure.

Hope this helps.

Pete

On May 3, 12:14 pm, Kev wrote:
Thanks so much Loudfish, Ireally appreciate your help.
It it the seperate sheet option I am trying to implement so that my boss has
easy access to quartery views of the yearly schedule.
Your solution works great on many levels but does not seem to transfer
colour, patterns or comments to Q1 from 'Summary'.
Most of the data on 'Summary is represented in colour/patterns and there are
many comments and hyperlinks.
Can i beg you to get back to me if there is a solution???
Kev

"loudfish" wrote:
On May 1, 5:11 pm, Kev wrote:
Please help, I have a 365 day schedule and want sheet tab 1 to show the whole thing then sheet tab 2 to show Q1 Jan - March.
So any data changed on sheet one the full year will be reflected in sheets 2 - 5 labelled Q1 - Q4?

Do you just need this so that they can be viewed / printed separately?
If so, play about with View....Custom Views on the menu.
Hide everything except Q1 information, then add a view, give it a name
"Q1".
Unhide everything, then hide everything except Q2 information, then
add another view, give it a name "Q2".
If you want to see Q1 layout, got to View.....Custom Views...click on
the one you want, and click Show.

If you need five separate worksheets?
Simplest way I know is to link every cell in the Q1 worksheet into the
correct place on the front worksheet (which I shall call "Summary").
e.g, in the Q1 worksheet, there would be a formula in cell A2:
=Summary!A2

When you update cell A2 in the Summary worksheet, the Q1 worksheet
will automatically update.

Be careful not to let anyone type anything directly into the Q1
worksheet - the update works in one direction only.

HTH

Andrew- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Its really nice of you to try to help Pete but the truth is the information
that is on the summary sheet is almost entirely expressed using block cell
colours (no calculations required). Its the colours that will be constantly
updated.
Also the =summaryA2 solution puts a zero in all the cells on the the Q1
sheet that are currently blank on the summery sheet??

I am begining to feel this may be beyond Excels capabilities?

It just seems so simple though - All i really want is for the cell A1 on
sheet 1 to always look exactly the same as cell A1 on sheet 2. Hmmm

"Pete_UK" wrote:

The procedure will copy formats (colours, fonts, conditional formats
etc) as a one-off, but the formulae you have been given earlier will
ensure that the data values reflect any changes to the values in the
summary sheet. It's only if you change the colours manually in the
summary sheet that you will have to re-apply the procedure.

Hope this helps.

Pete


On May 3, 1:21 pm, Kev wrote:
"Pete_UK" wrote:
As the layout is identical in all sheets, you can do this - highlight
all the Q1 data on the summary sheet and click <copy. Then select the
Q1 sheet in cell A1 and Edit | Paste Special | Formats (check) | OK.
This will copy the forrmats (only) to the Q1 sheet. Repeat for the
other quarters.

Sounds cool Pete and thanks,
but
Will this action continue to update the data in Q1 as it is entered into
summery (or vice versa?) or will i have to copy across the colours/Text every
time data is entered?



If the formats are changed on the summary sheet this will not be
reflected on the other sheets, but you can easily re-apply the
procedure.

Hope this helps.

Pete

On May 3, 12:14 pm, Kev wrote:
Thanks so much Loudfish, Ireally appreciate your help.
It it the seperate sheet option I am trying to implement so that my boss has
easy access to quartery views of the yearly schedule.
Your solution works great on many levels but does not seem to transfer
colour, patterns or comments to Q1 from 'Summary'.
Most of the data on 'Summary is represented in colour/patterns and there are
many comments and hyperlinks.
Can i beg you to get back to me if there is a solution???
Kev

"loudfish" wrote:
On May 1, 5:11 pm, Kev wrote:
Please help, I have a 365 day schedule and want sheet tab 1 to show the whole thing then sheet tab 2 to show Q1 Jan - March.
So any data changed on sheet one the full year will be reflected in sheets 2 - 5 labelled Q1 - Q4?

Do you just need this so that they can be viewed / printed separately?
If so, play about with View....Custom Views on the menu.
Hide everything except Q1 information, then add a view, give it a name
"Q1".
Unhide everything, then hide everything except Q2 information, then
add another view, give it a name "Q2".
If you want to see Q1 layout, got to View.....Custom Views...click on
the one you want, and click Show.

If you need five separate worksheets?
Simplest way I know is to link every cell in the Q1 worksheet into the
correct place on the front worksheet (which I shall call "Summary").
e.g, in the Q1 worksheet, there would be a formula in cell A2:
=Summary!A2

When you update cell A2 in the Summary worksheet, the Q1 worksheet
will automatically update.

Be careful not to let anyone type anything directly into the Q1
worksheet - the update works in one direction only.

HTH

Andrew- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

To get round the problem of blank cells coming across as zeroes, just
make the formula in A1 of the Q1 sheet:

=IF(Summary!A1="","",Summary!A1)

and copy across and down.

If there are no calculations on the summary sheet then you can just
highlight the relevant area of the summary sheet, click <copy then
select cell A1 of the Q1 sheet and press <Enter. This will copy both
the values and the formats into the Q1 sheet, and will only take a few
seconds whenever you need to do it.

Another way is to copy the Summary sheet itself (hold the CTRL key
down and drag the sheet tab), then highlight the columns you don't
want (i.e. for Q2 to Q4) and Edit | Delete, then rename this second
sheet as Q1.

For either of these approaches you could record a macro while you do
it once, allocate a key combination to it (eg CTRL-SHIFT_Q) and then
in future you would only have to repeat the keys to invoke the macro -
a few second's work.

Hope this helps.

Pete

On May 3, 3:44 pm, Kev wrote:
Its really nice of you to try to help Pete but the truth is the information
that is on the summary sheet is almost entirely expressed using block cell
colours (no calculations required). Its the colours that will be constantly
updated.
Also the =summaryA2 solution puts a zero in all the cells on the the Q1
sheet that are currently blank on the summery sheet??

I am begining to feel this may be beyond Excels capabilities?

It just seems so simple though - All i really want is for the cell A1 on
sheet 1 to always look exactly the same as cell A1 on sheet 2. Hmmm



"Pete_UK" wrote:
The procedure will copy formats (colours, fonts, conditional formats
etc) as a one-off, but the formulae you have been given earlier will
ensure that the data values reflect any changes to the values in the
summary sheet. It's only if you change the colours manually in the
summary sheet that you will have to re-apply the procedure.

Hope this helps.

Pete

On May 3, 1:21 pm, Kev wrote:
"Pete_UK" wrote:
As the layout is identical in all sheets, you can do this - highlight
all the Q1 data on the summary sheet and click <copy. Then select the
Q1 sheet in cell A1 and Edit | Paste Special | Formats (check) | OK.
This will copy the forrmats (only) to the Q1 sheet. Repeat for the
other quarters.

Sounds cool Pete and thanks,
but
Will this action continue to update the data in Q1 as it is entered into
summery (or vice versa?) or will i have to copy across the colours/Text every
time data is entered?

If the formats are changed on the summary sheet this will not be
reflected on the other sheets, but you can easily re-apply the
procedure.

Hope this helps.

Pete

On May 3, 12:14 pm, Kev wrote:
Thanks so much Loudfish, Ireally appreciate your help.
It it the seperate sheet option I am trying to implement so that my boss has
easy access to quartery views of the yearly schedule.
Your solution works great on many levels but does not seem to transfer
colour, patterns or comments to Q1 from 'Summary'.
Most of the data on 'Summary is represented in colour/patterns and there are
many comments and hyperlinks.
Can i beg you to get back to me if there is a solution???
Kev

"loudfish" wrote:
On May 1, 5:11 pm, Kev wrote:
Please help, I have a 365 day schedule and want sheet tab 1 to show the whole thing then sheet tab 2 to show Q1 Jan - March.
So any data changed on sheet one the full year will be reflected in sheets 2 - 5 labelled Q1 - Q4?

Do you just need this so that they can be viewed / printed separately?
If so, play about with View....Custom Views on the menu.
Hide everything except Q1 information, then add a view, give it a name
"Q1".
Unhide everything, then hide everything except Q2 information, then
add another view, give it a name "Q2".
If you want to see Q1 layout, got to View.....Custom Views...click on
the one you want, and click Show.

If you need five separate worksheets?
Simplest way I know is to link every cell in the Q1 worksheet into the
correct place on the front worksheet (which I shall call "Summary").
e.g, in the Q1 worksheet, there would be a formula in cell A2:
=Summary!A2

When you update cell A2 in the Summary worksheet, the Q1 worksheet
will automatically update.

Be careful not to let anyone type anything directly into the Q1
worksheet - the update works in one direction only.

HTH

Andrew- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Pete your a genius, Thankyou so much for your help.

"Pete_UK" wrote:

To get round the problem of blank cells coming across as zeroes, just
make the formula in A1 of the Q1 sheet:

=IF(Summary!A1="","",Summary!A1)

and copy across and down.

If there are no calculations on the summary sheet then you can just
highlight the relevant area of the summary sheet, click <copy then
select cell A1 of the Q1 sheet and press <Enter. This will copy both
the values and the formats into the Q1 sheet, and will only take a few
seconds whenever you need to do it.

Another way is to copy the Summary sheet itself (hold the CTRL key
down and drag the sheet tab), then highlight the columns you don't
want (i.e. for Q2 to Q4) and Edit | Delete, then rename this second
sheet as Q1.

For either of these approaches you could record a macro while you do
it once, allocate a key combination to it (eg CTRL-SHIFT_Q) and then
in future you would only have to repeat the keys to invoke the macro -
a few second's work.

Hope this helps.

Pete

On May 3, 3:44 pm, Kev wrote:
Its really nice of you to try to help Pete but the truth is the information
that is on the summary sheet is almost entirely expressed using block cell
colours (no calculations required). Its the colours that will be constantly
updated.
Also the =summaryA2 solution puts a zero in all the cells on the the Q1
sheet that are currently blank on the summery sheet??

I am begining to feel this may be beyond Excels capabilities?

It just seems so simple though - All i really want is for the cell A1 on
sheet 1 to always look exactly the same as cell A1 on sheet 2. Hmmm



"Pete_UK" wrote:
The procedure will copy formats (colours, fonts, conditional formats
etc) as a one-off, but the formulae you have been given earlier will
ensure that the data values reflect any changes to the values in the
summary sheet. It's only if you change the colours manually in the
summary sheet that you will have to re-apply the procedure.

Hope this helps.

Pete

On May 3, 1:21 pm, Kev wrote:
"Pete_UK" wrote:
As the layout is identical in all sheets, you can do this - highlight
all the Q1 data on the summary sheet and click <copy. Then select the
Q1 sheet in cell A1 and Edit | Paste Special | Formats (check) | OK.
This will copy the forrmats (only) to the Q1 sheet. Repeat for the
other quarters.

Sounds cool Pete and thanks,
but
Will this action continue to update the data in Q1 as it is entered into
summery (or vice versa?) or will i have to copy across the colours/Text every
time data is entered?

If the formats are changed on the summary sheet this will not be
reflected on the other sheets, but you can easily re-apply the
procedure.

Hope this helps.

Pete

On May 3, 12:14 pm, Kev wrote:
Thanks so much Loudfish, Ireally appreciate your help.
It it the seperate sheet option I am trying to implement so that my boss has
easy access to quartery views of the yearly schedule.
Your solution works great on many levels but does not seem to transfer
colour, patterns or comments to Q1 from 'Summary'.
Most of the data on 'Summary is represented in colour/patterns and there are
many comments and hyperlinks.
Can i beg you to get back to me if there is a solution???
Kev

"loudfish" wrote:
On May 1, 5:11 pm, Kev wrote:
Please help, I have a 365 day schedule and want sheet tab 1 to show the whole thing then sheet tab 2 to show Q1 Jan - March.
So any data changed on sheet one the full year will be reflected in sheets 2 - 5 labelled Q1 - Q4?

Do you just need this so that they can be viewed / printed separately?
If so, play about with View....Custom Views on the menu.
Hide everything except Q1 information, then add a view, give it a name
"Q1".
Unhide everything, then hide everything except Q2 information, then
add another view, give it a name "Q2".
If you want to see Q1 layout, got to View.....Custom Views...click on
the one you want, and click Show.

If you need five separate worksheets?
Simplest way I know is to link every cell in the Q1 worksheet into the
correct place on the front worksheet (which I shall call "Summary").
e.g, in the Q1 worksheet, there would be a formula in cell A2:
=Summary!A2

When you update cell A2 in the Summary worksheet, the Q1 worksheet
will automatically update.

Be careful not to let anyone type anything directly into the Q1
worksheet - the update works in one direction only.

HTH

Andrew- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -