Including a formula in a path

P

Peter

Dear All,

Is there a way of including a formula in a path.
Every month I have to repeat the same calculations on different file eg: File name month 1, month 2,3,4 etc. I have to change the path name many times. I'd like to be able to say +c:\Month +a1 etc where a1 is the month number.

The find and replace function doesn't work for a number of reasons. I tried concatenate but that involves fiddling around to get back to a path formula.

Any other ideas?

Many thanks
 
P

papou

Hi Peter
=INDIRECT("C:\Month" & A1 & ".xls")

HTH
Cordially
Pascal

Peter said:
Dear All,

Is there a way of including a formula in a path.
Every month I have to repeat the same calculations on different file eg:
Click to expand...
File name month 1, month 2,3,4 etc. I have to change the path name many
times. I'd like to be able to say +c:\Month +a1 etc where a1 is the month
number.
The find and replace function doesn't work for a number of reasons. I
Click to expand...
tried concatenate but that involves fiddling around to get back to a path
formula.
 
P

Peter

Very Helpful Papou - thank you!
Do you know of an additional / alternative method where you achieve the same tihing but are not required to have all the relevant work sheets open?
Many thanks
Peter
 
Top