F
Frothor
I am trying to take data from multiple sheets using the text from the top row
(see below). I have multiple spreadsheets named Y1Q1 etc. I was wondering
how I could put that into the formula so that I would grab Y1Q1!B7 etc. I
have a lot of info to input so a formula would be neccesary. Any help would
be appreciated.
Decision Y1Q1 Y1Q2 Y1Q3 ... Y4Q4
PRODUCT R&D ($1000/QTR.)
(see below). I have multiple spreadsheets named Y1Q1 etc. I was wondering
how I could put that into the formula so that I would grab Y1Q1!B7 etc. I
have a lot of info to input so a formula would be neccesary. Any help would
be appreciated.
Decision Y1Q1 Y1Q2 Y1Q3 ... Y4Q4
PRODUCT R&D ($1000/QTR.)