dynamic formulas


M

mns

Hi there.
I have excel documents named like January.xlsx, Feb...xlsx then to
December.xlsx.
And I have a huge file named Year.xlsx which has links from these month
files (all formulas are the same, sama cell numbers, same worksheet names
etc..).
What I would like to know is is there any way to choose the month name and
excel could update itself. for example:
='[January.xlsx]Workseet 1'!$G15

Lets say I will resever A1 for data cell and will make a dropdown list
there. When I select February I'd like excel to update all formulas from Jan
to Feb. It sounds too hard but I'm sure there is a way to make it. any ideas?
 
Ad

Advertisements

B

Bob Phillips

Personally I would merge all 13 workbooks into one workbook, with month
named sheets.
 
Ad

Advertisements

R

ruffnro

There is a function in Excel called INDIRECT which allows you to use a cell
reference in a formula. You would be able to write the formula to reference
the month cell that would be dynamic. The formula will be something like
=INDIRECT(A1&"Workseet 1'!$G15"). You may need to work through the
concatenation, but you should be able to get it to work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top