| 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!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lookup and populate with adjacent contents
Correction! The individual code should not be linked to the Lookup sheet.
Users will enter this value. I want to set up a lookup on the summary sheet. Sorry for the confusion. "Giggly4g" wrote: 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!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lookup and populate with adjacent contents
Nevermind. I actually figured this one out on my own. Guess it doesn't pay to
try and work when I'm ill. "Giggly4g" wrote: Correction! The individual code should not be linked to the Lookup sheet. Users will enter this value. I want to set up a lookup on the summary sheet. Sorry for the confusion. "Giggly4g" wrote: 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!!! |
| Reply |
| 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 | |||
Linear Mode
