Change data based on new data on different worksheet

[lawrence24]

Hi guys,

I've got two sheets. One is a month view, where each row represents the current day. So say, Row 1(A) I enter 300. On the second sheet, I need a specific cell to automatically take that number. The next day, when I enter a new number in Row 2(A), I need the same cell on the second sheet to erase what it had before, and change to the new one. Does that make sense?

Thanks,
Law

 

[Arithos]

This worked! Oh my god, thank you so much! If you were anywhere nearby, I'd buy you a year's supply of beer! :D Thanks again!

Haha, That would have been nice