Changing symbol on sheet A when it is changed on sheet B

Mily Oti

Hello,

I have two different sheets that contain similar data. One of the columns in sheet B is symbols. I am trying to write a formula where if the symbol is changed in Sheet B it will automatically be changed in sheet A. The columns on the two sheets have the exact name. Any help would be greatly appreciated.

Thanks,

Mily Oti

Andrée Starå

Hi @Mily Oti

Do you have something in both sheets that we could use as a unique value to connect the correct rows?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mily Oti

I'm not quite sure I understand your question.

Mily Oti

The first sheet is Sheet A and it is the Master sheet. The second one is Sheet B. When logs are not received, they rows are copied from Sheet A to Sheet B. Sometimes we receive logs late and then we have to make sure both sheets are updated. If I change the symbol in Sheet B, how could that be automatically changed on Sheet A?

Thanks,

Andrée Starå

@Mily Oti

I hope you're well and safe!

Excuse the late response.

Did you get it working?

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Mily Oti

No, not yet.

Andrée Starå

@Mily Oti

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)