Is this possible?

  • Thread starter Thread starter harry
  • Start date Start date
H

harry

sorry but only used the fairly common features of Excel & not sure if this
is possible?

I have a spreadsheet (currently in Excel 97 format) with 8 worksheets on,
there is some information I need visible on every worksheet - do I have to
copy & paste it to all 8 worksheets or is there a way of entering it only
once but still being visible globally?

hope I've made sense?

harry
 
harry, one way would be to put a formula in the sheets to ref. the cell
where you enter data, like this =Sheet1!A1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
good idea! thanks Paul


Paul B said:
harry, one way would be to put a formula in the sheets to ref. the cell
where you enter data, like this =Sheet1!A1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
Click to expand...
 
Harry, Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Back
Top