Reference another sheet

Eric Laitenberger

Hello,

I would like reference another sheet but the sheet reference name remained the same.

I would like reference into the Sheet Master but its blocked toanother sheet.

You can see in the print screen

Thanks to help me

sheet reference.docx

Genevieve P.

Hi @Eric Laitenberger

Based on this image, it looks like you're Editing a current reference instead of replacing a reference, is this what you were looking to do?

For example, if you have this formula in your sheet:

=COUNT({Column Reference})

And you clicked "Edit Reference" to change the column, this would update every single reference in your entire sheet to now look at the new column.

Instead, you would want to delete out the reference:

=COUNT({Column Reference})

to

=COUNT( )

Then click "Reference Another Sheet" and create a new reference to a new column. This way all your other formulas will stay looking at the previous column but now this new formula is looking at a different column. See: View, modify, or delete cross sheet references in formulas

Let me know if this makes sense or if I can help explain further!

Cheers,

Genevieve