I have a spreadsheet named "current month" Data that I open and rename each month to the current month's data. So in 12 months I have 12 files: Jan Data, Feb Data, etc. I have a second set of monthly spreadsheets named Jan Sales Tax, Feb Sales Tax, etc.
There is a specific cell in the Jan Data spreadsheet that I need in the Jan Sales Tax spreadsheet and the same cell is needed from the Feb Data spreadsheet in the Feb Sales Tax spreadsheet and so on.
Here is the Formula in the Jan Sales Tax spreadsheet that I change every month to reflect the current month's need.
There is a specific cell in the Jan Data spreadsheet that I need in the Jan Sales Tax spreadsheet and the same cell is needed from the Feb Data spreadsheet in the Feb Sales Tax spreadsheet and so on.
Here is the Formula in the Jan Sales Tax spreadsheet that I change every month to reflect the current month's need.
=+'[Jan Data.xlsx]Sheet1'!$A$7 Note: In Feb, I change "Jan" to "Feb", the remainder of the formula is not touched. Is there any way to make the "Jan" portion of the formula dynamic so that when I enter the applicable month in cell A1 - Jan or Feb or March, etc, the dynamic portion of the formula will change to whatever is in cell A1 thanks in advance!! |