Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a macro to help with lookup.
I want to be able to pull up clients by their name ( i have about 4
thousand clients) and after i do, i want it to show me multiple criterias.. for example.. the "DATE" he came in... HOURS worked.. "CREDIT" and "COMMENTS." I also want to be able to make adjustments /input more information if needed with in these criterias. in these rows i have: A1 "Client Name" jose josh mcarthe dan bush etc all the way down B1 "time" 1.5 3 1 3 4.25 C1 "Date" 1-12-07 2-04-07 04-08-07 etc D1 "Credit" 20 25 50 100 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a macro to help with lookup.
see reply to your other question
-- Regards Roger Govier "Jman" wrote in message ... I want to be able to pull up clients by their name ( i have about 4 thousand clients) and after i do, i want it to show me multiple criterias.. for example.. the "DATE" he came in... HOURS worked.. "CREDIT" and "COMMENTS." I also want to be able to make adjustments /input more information if needed with in these criterias. in these rows i have: A1 "Client Name" jose josh mcarthe dan bush etc all the way down B1 "time" 1.5 3 1 3 4.25 C1 "Date" 1-12-07 2-04-07 04-08-07 etc D1 "Credit" 20 25 50 100 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a macro to help with lookup.
I probably would use some named ranges for this and tie those named ranges to
a Validation list. I'm going to give an example for one and you can go from there. Insert - Name - Define - Enter "ClientName" (no spaces) in the RefersTo Box enter =offset('Sheet1'!A1,1,0,counta('Sheet1'!A:A)-1,1) THis assumes that you don't have anything after your list for ClientName in column A. Enter add and then put your cursor on the offset section to see the range displayed. You can also display your range with CTRL G and type in the range name. For the validation list, Data - Validation - Allow List and then enter "= ClientName" without the quotation marks. "Jman" wrote: I want to be able to pull up clients by their name ( i have about 4 thousand clients) and after i do, i want it to show me multiple criterias.. for example.. the "DATE" he came in... HOURS worked.. "CREDIT" and "COMMENTS." I also want to be able to make adjustments /input more information if needed with in these criterias. in these rows i have: A1 "Client Name" jose josh mcarthe dan bush etc all the way down B1 "time" 1.5 3 1 3 4.25 C1 "Date" 1-12-07 2-04-07 04-08-07 etc D1 "Credit" 20 25 50 100 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a macro to help with lookup.
This formula worked also.. Thanks for the reply,, keep up the good work.. I hope you guys get paid well for this..:) "Barb Reinhardt" wrote: I probably would use some named ranges for this and tie those named ranges to a Validation list. I'm going to give an example for one and you can go from there. Insert - Name - Define - Enter "ClientName" (no spaces) in the RefersTo Box enter =offset('Sheet1'!A1,1,0,counta('Sheet1'!A:A)-1,1) THis assumes that you don't have anything after your list for ClientName in column A. Enter add and then put your cursor on the offset section to see the range displayed. You can also display your range with CTRL G and type in the range name. For the validation list, Data - Validation - Allow List and then enter "= ClientName" without the quotation marks. "Jman" wrote: I want to be able to pull up clients by their name ( i have about 4 thousand clients) and after i do, i want it to show me multiple criterias.. for example.. the "DATE" he came in... HOURS worked.. "CREDIT" and "COMMENTS." I also want to be able to make adjustments /input more information if needed with in these criterias. in these rows i have: A1 "Client Name" jose josh mcarthe dan bush etc all the way down B1 "time" 1.5 3 1 3 4.25 C1 "Date" 1-12-07 2-04-07 04-08-07 etc D1 "Credit" 20 25 50 100 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does anyone know how to create a lookup that will do this? | Excel Worksheet Functions | |||
Does anyone know how to create a lookup that will do this? | Excel Discussion (Misc queries) | |||
Create Lookup Table | Excel Worksheet Functions | |||
how do i create a lookup | Excel Discussion (Misc queries) | |||
Create Total based on lookup value | Excel Worksheet Functions |