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