Automatically paste values when if statement is true

Hi guys

I'm busy doing reports at work and would like to make life a little easier and faster for that matter.

In Sheet1 I have a summary that compare two months' data with each other. I am also required to draw annual, bi-annual, quarterly and monthly reports (Sheet2). I have to manually type the data from Sheet1 into Sheet2 -- that gets irritating.

This is what I have so far in Sheet2:

=IF(A3=Sheet1!$C$1, Sheet1!$E$7, 0)

where

// A6 = Date (constant)
// Sheet1!$C$1 = Date (variable)
// Sheet1!$E$7 = Number (variable)

That brings the values to Sheet2. However, the moment I change Sheet1!$C$1, the value from Sheet2 changes and all data is lost.

I thought of creating an extra column that pastes the values of B3 (and on) into C3 and hiding Column B. Is it possible to paste values in the same column where the IF statement is written?

Please help me...

Regards

Inside u r if statment u can put another formula like
=IF(A3=Sheet1!$C$1, value(Sheet1!$E$7), 0)

Rasheed_Pro

Thank you for your reply. Your help kind of worked. I am still struggling with this damn thing. If you have time, please view the attachment - you might gain more understanding of what I am trying to do. My comments that tries to explain the whole thing is in red.

If you have any other suggestions of what I can do to achieve my goal, please let me know. I am open for correction and help.

Thanks for your efforts to help me!