LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Does anyone know how to create a lookup that will do this? Mascot Excel Worksheet Functions 3 July 26th 06 01:54 PM
Does anyone know how to create a lookup that will do this? Mascot Excel Discussion (Misc queries) 2 July 25th 06 08:51 PM
Create Lookup Table Matt Excel Worksheet Functions 3 February 28th 06 04:02 PM
how do i create a lookup RaPiDfIrE Excel Discussion (Misc queries) 1 May 10th 05 08:31 PM
Create Total based on lookup value Kim Excel Worksheet Functions 5 May 2nd 05 08:55 PM


All times are GMT +1. The time now is 09:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"