=IF($A$2=$B$2,'1st Shift'!$D$7,0)
A2=cell on yearly sheet
B2=cell on yearly sheet (for month of year =January)

On 1st shift sheet D7=month of year

I need to track data from the 1st shift sheet by month on the yearly sheet.
when I change the month in D7 1st shift sheet and replace with another month
I loose the data on the Yearly sheet

If its all formula driven then the data wont be static, i.e if Sheet2 A1
had a forumula like =Sheet1!A1 it will show you the data that is
currently in sheet1 cell A1 if you change the data in sheet1 cell A1 the
data will change in sheet 2. To be honest your question doesn't really
explain much, feel free to join our forum and make a post where you will
be able to upload a workbook for people to take a look at.


--
The Code Cage Team

Regards,
The Code Cage Team
www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=26436