| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup and populate with adjacent contents
Hi! I've got multiple indiv. company worksheets, a summary worksheet, and a
"lookup worksheet" that lists reps, mgrs, and codes. Currently, the cells of the summary worksheet are linked to each of the indiv. company sheets. Each code on the company worksheets is included on the lookup worksheet. I'd like to have the corresponding mgr and rep data auto-populate to the summary sheet. The summary code cell link to the individual sheet is =ABC!$D$1. The individual code cell link to the lookup is =Lookup!A2. B2 has the mgr data and C2 has the rep data. Your help is GREATLY appreciated!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with displaying the contents of the last populate cell. | New Users to Excel | |||
| Clear Contents of Adjacent Cell on Conditional Basis | Excel Discussion (Misc queries) | |||
| compare contents of two adjacent columns | Excel Worksheet Functions | |||
| Displaying contents of adjacent cells. | Excel Discussion (Misc queries) | |||
| Contents of adjacent cell from a function | Excel Worksheet Functions | |||
Threaded Mode
