if you have all the names of the sheets in G column you can apply in C Column
ie
G4 = Flex Form
and C4attached solution Works if all the sheets are called flex form (number)![]()
=INDIRECT("'"&G4&"'!B3")
if you have all the names of the sheets in G column you can apply in C Column
ie
G4 = Flex Form
and C4attached solution Works if all the sheets are called flex form (number)![]()
=INDIRECT("'"&G4&"'!B3")
Last edited by humdingaling; 05-31-2013 at 03:34 AM. Reason: split two solutions
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks