Update a referenced sheet without individual column formulas

noshiro

HI,

I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a unique row ID (to avoid pulling in the duplication of rows), without having to write individual formulas for each column?

I've been using INDEX MATCH for another sheet, but this master sheet is vast and would not want to create INDEX MATCH for each column.

Andrée Starå

https://community.smartsheet.com/discussion/138321/update-a-referenced-sheet-without-individual-column-formulas

Double post?

Hi,

I hope you're well and safe!

If the order never changes, you could use a VLOOKUP structure instead.

Another option could be to have one or more helper columns to collect data together, use INDEX/MATCH to the second sheet to some helper columns, and then split out the data from those.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

noshiro

Hi @Andrée Starå

Hope you are well. Thank you for your response. I do have a helper sheet. I want to use Index Match, but there are so many columns, I was being lazy and trying to find a way to Index Match the whole sheet in a bulk manner instead of column by column.

have a great weekend!