J
Jan B
I have forgotten how to reference a named range on another sheet in my
workbook. I have a YTD Summary sheet that I want to pull data into from my
monthly sheets in the same workbook. Monthly sheets are named Jan, Feb, Mar,
etc. Summary sheet in named Summary. Each of the monthly sheets has a cell
named Bills. The data on each monthly sheet is the same as the month before
it until changes for the germane month are entered. So, on the summary sheet
I don't want to see the data for that month until I'm in that month. Formula
for February should be something like the formula below, but I can't remember
how to do it!! Please help.
IF(MONTH(DATE)<=2,'Filename.xls'!sheetname[named range],0)
workbook. I have a YTD Summary sheet that I want to pull data into from my
monthly sheets in the same workbook. Monthly sheets are named Jan, Feb, Mar,
etc. Summary sheet in named Summary. Each of the monthly sheets has a cell
named Bills. The data on each monthly sheet is the same as the month before
it until changes for the germane month are entered. So, on the summary sheet
I don't want to see the data for that month until I'm in that month. Formula
for February should be something like the formula below, but I can't remember
how to do it!! Please help.
IF(MONTH(DATE)<=2,'Filename.xls'!sheetname[named range],0)