I am wanting to create a reference page for several of my sheets

Janelle

I have 3 different sheets; Projects, Code Request, and Insurance Claims. They all have the same information in the work order column. I would like to create a reference page merging some of the information from all sheets. When a row is added or changed on any of the three sheets, I want the system to look at the reference page and see if that work order number is there. If it is, I want it to update the columns from that sheet. If it isn't, I want the system to create a new row.

Basically, I want to look at this one sheet and know which work order goes with what project, code request, and/or insurance claim.

Andrée Starå

Hi @Janelle

I hope you're well and safe!

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet it will reflect on the destination sheet.

Would that work/help?

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!

Janelle

I will give that a try later this week.

Thanks,

Janelle

Andrée Starå

@Janelle

Excellent!

You're more than welcome!

Let me know 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!