How do I copy a worksheet name reference with embedded date and have date increment?
Posted on 2011-03-11
Hello Experts. I need your help again.
I have this formula in cell A1 and I want to copy it down for each day of the month:
=SUBTOTAL(9,'Z:\Production Reports\[PR 01-2011.xls]11-01-01'!G$11:G$600)
Cell A2 should look like this:
=SUBTOTAL(9,'Z:\Production Reports\[PR 01-2011.xls]11-01-02'!G$11:G$600)
My source workbook name is: PR 01-2011.xls
Each worksheet name represents a date, eg.: 11-01-02
You guys are so good at knowing how to save time/effort by writing formulas that can be copied. Can you help me with this one?