Workbook Copying

[djranks]

i have 5 sheets in my workbook. PSWeek1, PSWeek2 and so on

i went to PSWeek5 and tried to use =SheetPSWeek1!d10 to reference cel
d10 from PSWeek1 and not working. Thanks Guys

 

[Frank Kabel]

Hi
this should work. What happened for you (error, etc.)

 

[Steve H.]

Formula should be =PSWeek1!d10. You do not need the word Sheet.

Steve Hubbard

 

[Gord Dibben]

Drop the text "Sheet" from =SheetPSWeek1!d10

i.e. =PSWeek1!d10

Gord Dibben Excel MVP