DanG
Registered User.
- Local time
- Today, 06:50
- Joined
- Nov 4, 2004
- Messages
- 477
Hello,
I would like to modify the formula below to get the "Baker, Tom" part of the formula from a cell like "A1" and am not quite sure how to do it?
Row A contains the names of the other worksheets.
Thank you
I would like to modify the formula below to get the "Baker, Tom" part of the formula from a cell like "A1" and am not quite sure how to do it?
Row A contains the names of the other worksheets.
Code:
=SUMPRODUCT(--('C:\Documents and Settings\MyProfile\Desktop\Meeting\Lists\[Baker, Tom.xls]Baker, Tom'!$F$2))
Thank you