Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Range Mess | Charts and Charting in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |