Re-using formulas with reference on multiple sheets

Kevin_KK

Hello,

Is there any way for us to re-use the formulas created that reference a specific sheet? Or do we need to manually create the reference for each sheet where we are trying to use the formula on?

I'm trying to create general formulas using the MATCH function which is referencing the lookup table from a specific "Master" sheet. I want to apply said formulas on various sheets without needing to basically re-do them every time I want to use them on a different/new sheet.

Thanks,

Kevin

Andrée Starå

Hi @Kevin_KK

I hope you're well and safe!

Unfortunately, you'll have to recreate them for each sheet, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!