VBA Code To Mirror Cells from one Worksheet to another based on sequence number

[jarrinsonp]

I need to mirror individual cells from one worksheet to another but each transaction has a unique sequence number so the cell should mirror the right transaction based on its Seq. number

I've attached a file with two worksheets. The MasterData in one and a report extracted from the MasterData. I would like to mirror the comments field so each time a user input data in the comments field it mirrors the info to the same transaction in the masterdata.

I really appreciate all the help you can provide.


Thank-you,
Jarrinson

[pike]

Hi jarrinsonp,
Welcome to the forum
if the seq# are filter in decending order then in

the report sheet AB2 =INDEX(MasterData!Q:Q,MATCH(A2,MasterData!A:A))
fill down

[jarrinsonp]

Hi jarrinsonp,
Welcome to the forum
if the seq# are filter in decending order then in

the report sheet AB2 =INDEX(MasterData!Q:Q,MATCH(A2,MasterData!A:A))
fill down

Thanks mate, but I'd like to mirror the info from the report to the masterdata.this formula is the other way around.

Cheers,
Jarrinson

[pike]

Hi jarrinsonp
Can attach a before and after example as I not too sure what you need?