workng bet wrksheets

  • Thread starter Thread starter Vashni
  • Start date Start date
V

Vashni

I am working on a project.
I want to create a document where I input all the info required on sheet 1
and this is automatically entered to the rest of the sheets, in specific
cells.
eg. call sheet 1 "info", here i input the clients name and this is
automatically entered in the next few sheet but at specific location where
this clients name is required. How do I do this?
Thanks
 
Suppose you enter Client Name in Cell A of Sheet "Info"
then put this anywhere you want to get the same Client Name
=Info!A1

If there are spaces in the sheet name then use this
='Info Sheet'!A1
 
Referrence the cells ,
Place
=Sheet1!A1
into Sheet2 A1 and it will reference that cell.
 
Back
Top