Hi George.
That would work fine if all the pages were the same but some of the boxes
are in different positions. So when i did that , it worked fine but on the
other pages ie:2,3,4and 5 it would not come up in the relevent spaces.The
problem i am having is that when i try to copy the existing data from the
first page, i get an error message ie: #value. if i try to copy straight from
the 2nd page it works fine. Just the first page has got me stumped.

"George Gee" wrote:

Sorry, instructions incomplete!
Should read:

Click on the sheet tab of the first sheet,
hold down the shift key,
click on the sheet tab of the last sheet
This groups the sheets together.

George Gee

"George Gee" wrote in message
...
Click on the sheet tab of the first sheet,
hold down the shift key.
This groups the sheets together,
anything typed on the first sheet will appear on all sheets.
To ungroup, right-click the tabs and select 'Ungroup Sheets'.

George Gee



"bigjim" wrote in message
...
Hi,
I have an excel spreadsheet that i use for work and it has 6 different
pages. Some of the pages have the same information as the first page. How
can
i get the info from the first page to appear on all the other pages
without
typing it into every page? I have tried to do the = on the last page and
carry it to the first page and press enter but on the last page all i get
is
#value. Could someone please tell me what i am doing wrong.
thanks Jim.