In my Cell C7 I have a linked formula:
=SUM('C:\Users\Owner\Documents\AAA-RNFC\2017\July\[GR POS MASTER REPORT.xls]Master SALES'!$C$95)
In Cell $D$1 I have the Text: JULY
How do I modify my C7 formula to replace my hard-coded "JULY" with only a Reference to Cell $D$1?
Thanks in Advance