Date Increment by one month

Hi,

I'm using Excel 2007 and I'm trying to develop a workbook to track employee stats based on our fiscal year which runs from Nov to Oct each year. I have monthly worksheets to track stats by month and a worksheet for year to date stats as well I have individual worksheets for each employee

The issue I'm having is as follows:

1. on the employee stat worksheet I have various cells that need draw info from cells in the current month worksheet to populate. Is there anyway to do this without manually changing or doing find/replace

Thanks

If you could attach a workbook sample, we could help you a bit more.

I would go with SUMPRODUCT or Index-Match, depending on the nature of the information.

If it's all numbers and you're matching a single statistic, SumProduct would work fine.


=SUMPRODUCT((range=reference)*(rangeofdata))

This would be something like:

=SUMPRODUCT((Sheet2!a1:a999=d10)*(Sheet2!b1:b999=e10)*(Sheet2!c1:c999))

This would pull the sum of data in Column C, where A matched the date and B matched the item.

Thanks for the options I will try them to see which one works best!