Ref cell in another worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All

Sorry for the very basic question. I have several worksheets in a workbook and have named the first sheet 'Info'. This sheet holds such data as 'contract number' and 'user name'..... This data is required on all the other sheets but i would like to just reference the data from the 'Info' sheet

What do i have to enter on the other sheets so that this info only has to be entered on the 'Info' sheet

How do i reference this data/info from the 'Info' sheet in the header/footer of printed sheets

Thanks for any/all help

Sal
 
Select the sheets you want then enter on the info sheet.

--
Don Guillett
SalesAid Software
(e-mail address removed)
Sal said:
Hi All,

Sorry for the very basic question. I have several worksheets in a workbook
Click to expand...
and have named the first sheet 'Info'. This sheet holds such data as
'contract number' and 'user name'..... This data is required on all the
other sheets but i would like to just reference the data from the 'Info'
sheet.
What do i have to enter on the other sheets so that this info only has to
Click to expand...
be entered on the 'Info' sheet?
How do i reference this data/info from the 'Info' sheet in the
Click to expand...
header/footer of printed sheets?
 
Thanks for your response Don, but i will be adding sheets from a collection of standard templates so additional sheets will be copied in at later dates. What i'm trying to do is something like:

='Info'!B2

but this isn't working.

Sal
 
Back
Top