peter renton 
Hi All
I have attached a small wb, this mirrors certain cells from sheet1 to sheet 2 but because it jst mirrors it copies them into the
same row on sheet two. I need the data to update if it is changed in sheet one but would like it to be entered into the first
row with column a blank.
the reason being is that the full wb has an auto row deletion depending on a given date which would then delete a row in sheet one and because its
mirrored would leave blank rows in sheet 2.
Idealy if the data could be copied over and be amended if changed but not be deleted if sheet 1 is cleared that would be spot on.
Sheet 2 will be a summary profit/loss sheet
If there is a better ideal rather than mirror data i am open to any sugestions
thank you in anticipation
Peter
Bookmarks