Is this possible?

[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

[Paul B]

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

"harry" <[email protected]> wrote in message
news:[email protected]...
> 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]

good idea! thanks Paul


"Paul B" <[email protected]> wrote in message
news:#[email protected]...
> 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
>
> "harry" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> >
>
>

[Paul B]

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

"harry" <[email protected]> wrote in message
news:%[email protected]...
> good idea! thanks Paul
>
>
> "Paul B" <[email protected]> wrote in message
> news:#[email protected]...
>> 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
>>
>> "harry" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>> >
>> >
>>
>>
>
>