PDA

View Full Version : Excel formula



wes2706
10-11-2017, 06:43 AM
I have an excel formula that looks like this....

='S:\Sales\Level 1\Daily Reporting\Daily Progress Report\[Bethel Daily Report - November 2017.xlsx]011117'!$M$16

But the word "Bethel" needs to be taken from a different cell B3, as it will vary each time.
Same with the phrase "November 2017" which comes from cell C4.


How can I automate this?

SamT
10-11-2017, 11:20 AM
MAybe...
='S:\Sales\Level 1\Daily Reporting\Daily Progress Report\[&B3& Daily Report - &C4& 2017.xlsx]011117'!$M$16
:dunno: