Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List details in another sheet
Hi, I have a sheet "Data" with transactions by customer. Column A has
the Customer ID. In another sheet called "By Customer", the user selects from a drop down a Customer ID, and clicks a button. What I want for this button is to run a macro to get in a 3rd sheet, "Transactions", columns B, C, D and E from the Data sheet, for the selected customer ID. Is that possible? Can somebody help? Thanks, Cecilia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List details in another sheet
Use VLOOKUP
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm -- Regards Dave Hawley www.ozgrid.com "Chechu" wrote in message ... Hi, I have a sheet "Data" with transactions by customer. Column A has the Customer ID. In another sheet called "By Customer", the user selects from a drop down a Customer ID, and clicks a button. What I want for this button is to run a macro to get in a 3rd sheet, "Transactions", columns B, C, D and E from the Data sheet, for the selected customer ID. Is that possible? Can somebody help? Thanks, Cecilia |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
List details in another sheet
On May 3, 11:13*pm, "ozgrid.com" wrote:
Use VLOOKUPhttp://www.ozgrid.com/Excel/excel-vlookup-formula.htm -- Regards Dave Hawleywww.ozgrid.com"Chechu" wrote in message ... Hi, I have a sheet "Data" with transactions by customer. Column A has the Customer ID. In another sheet called "By Customer", the user selects from a drop down a Customer ID, and clicks a button. What I want for this button is to run a macro to get in a 3rd sheet, "Transactions", columns B, C, D and E from the Data sheet, for the selected customer ID. Is that possible? Can somebody help? Thanks, Cecilia- Hide quoted text - - Show quoted text - Thanks Dave, but I need VBA for this, not formula. Transactions file is a weekly file with over 50.000 rows, and I may have none, one, two, n transactions from the selected customer. I can't use just vlookup here. Any idea?? Thanks, Cecilia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using List details within a sum | Excel Worksheet Functions | |||
getpivotdata to show details as a list | Excel Worksheet Functions | |||
formula on link and drop down list details | Excel Discussion (Misc queries) | |||
How do i pull details from a table to appear as a list in excel? | Excel Programming | |||
details of a pivottable always in one sheet | Excel Programming |