Jim I think your initial approach was correct. I have a 9 page (Tabs)
workbook that does what you want. I clicked "=" on the Tab 2 entry I wanted
the duplication to appear in , then clicked Tab 1 and the cell containing the
data to be duplicated "Enter". If you are getting a #value after doing this
I'm guessing your format on tab 2 isn't correct or the cell is to small. Once
the Tab 2 formula is correct you should be able to copy and paste it onto all
additional Tabs (easier than performing same functiuon for all sheets). This
formula will negate the "0" that appears if the duplicated cell (A1) is empty
=IF(Sheet1!$A$1<"",Sheet1!$A$1,"")
HTH
Lou

"bigjim" wrote:

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.