IF Formula

E

EAG

=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
 
T

The Code Cage Team

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

--
The Code Cage Tea

Regards,
The Code Cage Team
www.thecodecage.co
 
Top