ANTONIO1981
Board Regular
- Joined
- Apr 21, 2014
- Messages
- 162
Hi all
I Have the following formula in a spreadsheet with several tabs per month with the same layout.
=(March!D$54+March!D$55+March!D$56+March!D$62)/March!D$7
i would like to have the month name written in cell F1.
so when I change F1 to April or other Month name the formula changes picking the information from the April tab.
I tried to write the formula indirect unsuccesfully..
many thanks in advance!
Antonio
I Have the following formula in a spreadsheet with several tabs per month with the same layout.
=(March!D$54+March!D$55+March!D$56+March!D$62)/March!D$7
i would like to have the month name written in cell F1.
so when I change F1 to April or other Month name the formula changes picking the information from the April tab.
I tried to write the formula indirect unsuccesfully..
many thanks in advance!
Antonio