How to fill a range with data from another range?
 

Hello people!

I hope someone could help me - I think what I need is not very complex, but
I can't figure it out for the life of it!

I have a list of customers and each of them gets a specific kind of discount
for each product category (so in effect I've got a table, say 50 rows down by
10 columns accross).

What I need to do is, on a different sheet, to be able to have a dropdown
list with the customer names (I know how to do this), and when I choose a
customer from the list a table nearby will be filled with the discount values
from the aforementioned sheet.

Anyone can tell me of a simple way to do this? Do I need to go pivot-y?

Thank you in advance :)
Th

A simple VLOOKUP, Themis. Try this:
http://www.officearticles.com/excel/...soft_excel.htm
And perhaps something like this will help you as well:
http://www.officearticles.com/tutori...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Themis" wrote in message
...
Hello people!

I hope someone could help me - I think what I need is not very complex,
but
I can't figure it out for the life of it!

I have a list of customers and each of them gets a specific kind of
discount
for each product category (so in effect I've got a table, say 50 rows down
by
10 columns accross).

What I need to do is, on a different sheet, to be able to have a dropdown
list with the customer names (I know how to do this), and when I choose a
customer from the list a table nearby will be filled with the discount
values
from the aforementioned sheet.

Anyone can tell me of a simple way to do this? Do I need to go pivot-y?

Thank you in advance :)
Th

Hello Anne,

Thank you so much for your quick reply! This seems to sum it up quite
nicely, I think it will work... Thanks again!

Th

"Anne Troy" wrote:

A simple VLOOKUP, Themis. Try this:
http://www.officearticles.com/excel/...soft_excel.htm
And perhaps something like this will help you as well:
http://www.officearticles.com/tutori...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

Terrific!
************
Anne Troy
www.OfficeArticles.com

"Themis" wrote in message
...
Hello Anne,

Thank you so much for your quick reply! This seems to sum it up quite
nicely, I think it will work... Thanks again!

Th

"Anne Troy" wrote:

A simple VLOOKUP, Themis. Try this:
http://www.officearticles.com/excel/...soft_excel.htm
And perhaps something like this will help you as well:
http://www.officearticles.com/tutori...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

Indeed! These discussion groups have always proved so helpful for me, with so
great people REALLY providing help! :)

Cheers
Th


"Anne Troy" wrote:

Terrific!
************
Anne Troy
www.OfficeArticles.com