Referencing another WB's cells, but not formulas/values.
Thanks Fred - My example isn't entirely accurate, as I really do not want to
pull any values off WSA, EXCEPT the names... WSB values will be entered
separately, by hand.
Sorry if this makes no sense... basically, I want to keep the names on WSB
current by pulling them off of WSA, but not pulling any other values off of
it.
"Fred Smith" wrote:
Use Match to find the row number the student is on in WS A, and then Index to
access a particular cell on that row. Then copy or formulate the result in each
column (depending on how you get 'FTO' from 'Absent'). Something like:
B2: =index(WSA!A:Z,match(a2,WSA!A:A,0),2)
--
Regards,
Fred
"anna" wrote in message
...
I have an attendance worksheet (A) and need to create an addition spreadsheet
(B) that will reference only the names from the first worksheet.
My issue is that WS A is constantly changing (names added/deleted) and WS B
needs to keep the rows matched up with the correct people (see below):
WS A
Jan 1 Jan 2
Jon Doe Absent
Jack Bauer Absent
Zoe Zoe
WS B
Jon Doe FTO
Jack Bauer FTO
Zoe Zoe
.... SO, Jon Doe was deleted... WS B would look like this:
Jack Bauer FTO
Zoe Zoe FTO
Which is incorrect... any suggestions?
|