View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jman Jman is offline
external usenet poster
 
Posts: 110
Default 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