Is it possible to update a cell in worksheet A based on a value in worksheet B? Maybe I can explain it better. I have a worksheet ("Worksheet 1") with columns A thru D for example that I send to end users. They add a columm E and insert comments to explain certain rows of data. Two days later I'll refresh the information and send them a new worksheet ("Worksheet 2") with columns A - D.
Is it possible to update column E on "Worksheet 2" with values from column E on "Worksheet 1" where column A in "Worksheet 2" matches column A in "Worksheet 1"? I hope this makes sense.
Is it possible to update column E on "Worksheet 2" with values from column E on "Worksheet 1" where column A in "Worksheet 2" matches column A in "Worksheet 1"? I hope this makes sense.