Linking a Row to a cell that gets sorted by autofilter.

[jdelafuente]

I need help,

I have a simple but important idea, and I am at a standstill. I have a table that I am using autofilter to sort the columns (First worksheet). Column A in all the worksheets are names of countries. The first worksheet then enables countries to be prioritized by the autofilter drop down selection. I would like to link rows in the following worksheets (Column A being linked back) to that initial sort, so that the rows of info are then prioritzed based on the selection in the initial sheet. Hard to explain, so I am attaching the worksheet (a demo). I know you can link back cells easily, I know how to do that. By I need the entire row to move relative to Column A in the initial sheet.

Guys, Thanks a bunch.

If you can think of another way to do what I want pls tell me. The prob is I am using follow on worksheets that have 1000's of rows of data. So I want an easy way to prioritize based on my initial selections.

Just a heads up, on the initil sheet, 0 means doesnt contribute (no) to the objective, 1 means contributes (Yes). It will make sense when you look at it.

R
Manny

[jdelafuente]

Sorry, correct file attached!