Hello all,

I am building a balance sheet for my personal finances. New year, new start and all that jolly stuff. Instead of using a pre-made sheet I want to learn to make it myself.

I have set up a layout that auto fills in data in Column H when data is added to either column F or G, simple stuff. However I have a workbook that contains months of the year and each new month will pull the data from the last transaction from for example, cell H4.

However I would like to add a "watcher" that will follow column "H" and the rows.

So in short I like data from a cell in column "H" for example "H4" from sheet 1 to show on sheet 2 "H1" and if data is entered into cell "H5" excel will "see" this and report that data to sheet 2 "H1" instead.

Really sorry if that doesn't make sense.