There are two things to do here - change the text on Wednesday's
sheet, and then have this propagate through to the remainings sheets.

First of all, you can fix the value in the cell on Wednesday's sheet:
select the cell, click <copy, then right-click on the cell and choose
Paste Special | Values | OK then <Esc. Now you can amend the text in
that cell as you wish.

Then you need to click on Thursday's tab to select that sheet, and
then hold the CTRL key down while you also click on the tabs for
Friday, Saturday and Sunday - this will group them together so that
any change on one sheet will affect them all. Select the corresponding
cell that you changed for Wednesday and change the formula so that
instead of:

=Monday!A1

this gets changed to:

=Wednesday!A1

or whatever your cell reference is.

Then you can ungroup the sheets by clicking on the tab for Wednesday.

Hope this helps.

Pete

On Jan 28, 12:26*pm, Terry wrote:
Hope someone can help with this!!

Here's roughly what I need to do - as an example, I have, essentially, 7
tables of daily information that begins as exactly the same data for each day
- i.e. each day's information is a copy of what is inputted for Monday, so
for the remainder of the week, I will be using, for example "=Monday!A1" for
each other day.

Now, what I need to be able to do is on Wednesday, for example, change
perhaps a few words of the information (at the moment, a copy of what is on
monday), but for this new change to be carried forward for the remainder of
the week.

This is a simplified version of what i need to do, but what I suppose I'm
asking is how I can progressively change information that only starts off as
a copy of text in an initial table of information.