Keeping Cell data together after being sorted on a separate sheet

[Raindrop_001]

How do you keep a row of cells together when the first cell in the row is being sorted by a sort function on a separate Page. currently, when the NY, PA & OH cells are sorted on page 1, the data next to them is mixed.

 

[Alex Blakenburg]

No worries.
Yes pulling data from one Table of Data into another Table of Data using just cell = cell is not the way to go in Excel.
(It is ok for static data such as headings etc)
You want one table to be the master and the other to pull additional data from it using lookup formulas.
Alternatively one being the Transaction Table and the other a summary table and then pull data with a combination of Lookup, and aggregation functions with or without a lookup like capability eg SumIfs, CountIfs, Maxifs aggregate with criteria.

 

[Raindrop_001]

No worries.
Yes pulling data from one Table of Data into another Table of Data using just cell = cell is not the way to go in Excel.
(It is ok for static data such as headings etc)
You want one table to be the master and the other to pull additional data from it using lookup formulas.
Alternatively one being the Transaction Table and the other a summary table and then pull data with a combination of Lookup, and aggregation functions with or without a lookup like capability eg SumIfs, CountIfs, Maxifs aggregate with criteria.

That makes a lot of sense. I appreciate you helping and leading me in a good direction though. I've been usually Excel for a while, but mostly for very simple calculations. I'm not completely sure how to use all is functions yet, so this helped

 

[Alex Blakenburg]

Glad it has been some help, even if though it was not what you were hoping for.
I am sure you will have some more question later on.