| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing another WB's cells, but not formulas/values.
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Lookup Function Referencing cells, not text values | Excel Worksheet Functions | |||
| How do I avoid referencing hidden values in formulas like OFFSET? | Excel Worksheet Functions | |||
| formulas referencing pivot table cells | Excel Worksheet Functions | |||
| How do I view formulas by values not by which cells they use to c. | Excel Discussion (Misc queries) | |||
Threaded Mode
