I used your explanation on connecting information from sheet to sheet in Excel and it worked great but I would like to know how to write the formula so that the value will change on sheet 2 when it is changed on sheet 1 automatically if I have to make any changes ? (I am doing year end receipts)