Creating a formula that references other sheets

W

WisconsinMike

I am trying to create a formula that will reference other sheets within my
spreadsheet and maintain this reference even if I sort the data or move the
cell that I am referencing. I tried using the absolute functions, but that
did not work. This is an example of my function.
=Appleton!B2+'Oshkosh S'!B2+'Oshkosh N'!B2+Chatfield!B2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Response immediately? 0
External cell reference between two excel worksheets both in One Drive 0
Using a worksheet function to create an unusual cell reference pat 3
Cross reference drop down not activating 1
VLOOKUP and MID Function 9
Formulas Still Not Working 5
how do I create a nonadjacent series for autofill to go by? 3
Combine data into central worksheet 1

Top