Automating advancing from one worksheet to another

[lauraw100]

2 workbooks. One called "Cash Flow"; the other called "Budget"

In the workbook Cash Flow, there are different months on each worksheet (January, Feb etc).
Within Budget, there are columns titled Jan, Feb, etc.

I want to pull a specific cell or range of cells within January (Cash Flow) and have it appear under January in the Budget workbook. That's fine. Simple formula. But I want to be able to drag that formula across the page, so that the formula auto advances to the next month. Haven't been successful.

Current formula: =[00525144.XLSX]January!$C$6
If I drag it to the next cell, it simply pulls the same information from January

Sure could use some help.

 

[James006]

Hi,

Not sure to understand the structure of your worksheet ...

But if in cell B1 you have January ...then February in C1 ...you could test :

=INDIRECT("[00525144.XLSX]"&B1&"!$C$6")

Hope this will help