Employer Spreadsheet

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

OK, First, I am fairly new to Excel 2003 but so far I
have been able to figure most everything out for myself.
But one thing is puzzling me...When a employee signs
into, lets say Column A, I need for Column J to report
which Manager they report to. Consider there is over 200
employees and only 5 managers, I am not sure how to do
this. Any suggestions would be greatly appreciated.
Thanks in advance!
 
-----Original Message-----
Hi
you could set-up a lookup range with your manager names in it and use a
drop-down list for this. see:
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany



.
I appreciate the previous solution, but I forgot to
Click to expand...
mention one thing.......The information that is coming to
excel workbook is from a web based application which is
updated every 2 minutes. Now the cell that the managers
name would be reported to is a cell which is not sharing
that info. I cannot change the info from the other cell
without losing the ability of the automatic refresh. So
my problem is that whomever sign into cell A1 today their
permanent manager would be reported to cell J1, but if
that same person would sign into A(?) tomorrow the same
manager would be reported to J(?). Ultimately it my goal
to make a list out of column J so I can group all
employees together by manager. Sounds like an easy
problem and normally it would be but you see the Managers
name is no where on the web based application where all
the other raw data is coming from. So, somehow I have to
link the employee which is coming from the web based
application to the correct manager and be able to display
that info in column J no matter if they are the first to
sign in or the last. So, If they sign into A9 then the
manager is going to be reported in J9. I hope I explained
that right?
 
Back
Top