Auto update columns across sheets

Auto update columns across sheets


I use a form to collect details from participants. This goes in a participants sheet (1).

The name and the country of residence (and none of the other collected information) I want to use in another sheet (2) and add some other columns of information to them. So I linked the the columns in the new sheet (2) to the sheet (1) that collects the information with the form.

I see the link indicated (little blue triangle) in the sheet (2) but when new names are added in sheet (1), the sheet (2) is not updated.

How can I make this update in sheet (2) happen?

Thank you for your help.


Best Answer


  • Hi Andrée,

    Yes, I used cell linking.

    VLOOKUP. I will give it a try even though this spreadsheet knowledge is a bit rusty.

    Thank you for your help and have a good and safe weekend too!


  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 06/29/20

    @Victor van R

    You're more than welcome!

    Let me know how it goes and if you have any questions!

    Remember! 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!


    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.