S
Steven Powell
I am having difficulty with a formula. I have a workbook
that contains about 14 worksheets. 12 of the worksheets
represent the months of the year, and they are all named
as such. I am attempting to track numerical data
pertaining to each month. But, on the summary sheet, I
want to be able to enter the date in a field, and it puts
the total numbers in designated fields relating to month I
entered. Each month is on its own worksheet. How can I
make the number represent the month every time. Example:
Book placements are cell L5 on every worksheet, so the
formula has to pull the number from L5 on whatever month
entered. Can someone assist me?
that contains about 14 worksheets. 12 of the worksheets
represent the months of the year, and they are all named
as such. I am attempting to track numerical data
pertaining to each month. But, on the summary sheet, I
want to be able to enter the date in a field, and it puts
the total numbers in designated fields relating to month I
entered. Each month is on its own worksheet. How can I
make the number represent the month every time. Example:
Book placements are cell L5 on every worksheet, so the
formula has to pull the number from L5 on whatever month
entered. Can someone assist me?