Sort by name - populate cell on diff sheet with that name

  • Thread starter Thread starter mrsimps
  • Start date Start date
M

mrsimps

I'm trying to do a "score card" for people. I have my formula's all set
up and I'm completely stumped on one thing.

On one sheet I have all my users by column and auto sort turned on.
I'm trying to link a cell on a different sheet (the score card) to
populate the name I sorted by on the first sheet.

(this made more sense before I started typing)

If anyone can offer some advise I'd be forever gratefull! ;-)

Michele
 
I think I'd use a macro to do it. And I'd steal as much as I could from Debra
Dalgleish's site:

There are a couple of files here:

http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb
 
Back
Top