lookup and populate with adjacent contents

G

Giggly4g

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!!!
 
G

Giggly4g

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.
 
G

Giggly4g

Nevermind. I actually figured this one out on my own. Guess it doesn't pay to
try and work when I'm ill.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Look up in another sheet for values to return in 1st worksheet 2
Populate Data from Summary Sheet 5
Lookup to create a table of data in terms of selection 1
Filter and List Question 1
Returning adjacent values 2
loop through code and refernce text file for info 1
Transfering data from 1 worksheet to another 1
Copy Cells from multiple Worksheets in same workbook. 2

Top