Sorting data linked to other spreadsheets

  • Thread starter Attempting to be excel savvy
  • Start date
A

Attempting to be excel savvy

Everytime I sort data on my main spreadsheet the spreadsheets that are linked
get a lot of #REF! errors. The formulas in my other spreadsheets are all
similar to:

=IF('Enrollment Log'!$B491=4099, 'Enrollment Log'!$H491, " ")
=IF('Enrollment Log'!$B492=4099, 'Enrollment Log'!$H492, " ")

When the data is re-sorted if there was originally data the met the above
criteria in cell B491 but it moved then that cell will produce an error of
#REF! Is there a way I can fix this?
 

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

Help! Need to update linked SQL table in Acc07 3
sorting source data linked to another sheet 0
Sorted data values changed 2
linking between spreadsheets 5
Sorting Linked Data Between Sheets 3
Data Sort 5
Sorting Spreadsheet Selection - Recurring Sort 0
can a linked spreadsheets sort automatically when data is added 2

Top