Sort Formulas?

  • Thread starter Thread starter iturnrocks
  • Start date Start date
I

iturnrocks

Is there a way that I can sort data on one sheet and have the formulas
that link to this data automatically update?

Sheet 1
___A___B___
1__82_____
2__40_____
3__77_____

Sheet 2
________A__________B____________C_______
1__=Sheet1!A1___=Sheet1!A2___=Sheet1!A3__


Sort Column A, Sheet 1 Ascending
1__40
2__77
3__82

Sheet 2 Updates
1__=Sheet1!A2___=Sheet1!A3___=Sheet1!A1
 
There may be a better way, but you could use a helper column in both
worksheets.

In the helper column on Sheet1, number 1, 2, 3, etc.
A B
1 40
2 77
3 82


Put the same helper column on Sheet2, then use
=VLOOKUP(A1, Sheet1!A$1:B$3, 2, 0)

When you sort the data on Sheet1, include the helper column in the sort.
 

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

Drop Down with dynamic named range offsheet source list 14
Cell Reference 1
Sorting data does not expand to other sheets 3
using CountIF function or Array? 3
Build a reference to another worksheet from cell values in currentsheet 3
Variable to rename a tab in a worksheet via VBA 5
SUMIF division 2
How Do I Avoid #REF! In Formulas? 4

Back
Top