"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 -