J
JimDandy
I am trying to create a spreadsheet that collects data from a number o
similarly formatted worksheets. Since I don’t want to have to manuall
enter each sheet name into the main collection worksheet formulas
would like the formulas in each column to reference data from th
worksheet bearing the name of that formulas’ column header.
For instance, in a column labeled “03” I want to reference a workshee
named “03” in this formula but if I copy this formula across t
multiple rows I need to edit each row and change the “03” to “02”, “01
etc…I know I can edit and replace but my main worksheet collects dat
from many worksheets.
=SUMPRODUCT(--(MONTH('03'!$D$6:$D$76)=1),'03'!$J$6:$J$76
similarly formatted worksheets. Since I don’t want to have to manuall
enter each sheet name into the main collection worksheet formulas
would like the formulas in each column to reference data from th
worksheet bearing the name of that formulas’ column header.
For instance, in a column labeled “03” I want to reference a workshee
named “03” in this formula but if I copy this formula across t
multiple rows I need to edit each row and change the “03” to “02”, “01
etc…I know I can edit and replace but my main worksheet collects dat
from many worksheets.
=SUMPRODUCT(--(MONTH('03'!$D$6:$D$76)=1),'03'!$J$6:$J$76