View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EBnLP01 EBnLP01 is offline
external usenet poster
 
Posts: 8
Default Loop or Find code ?? need help !!

............A...........B.............C........... D
1.........EB.........TF...........JAH........45
2.........RG........TF............JAH.......78
3.........EB..........BE............NC.......99

Description :
Column "A" = Draftsman
Column "B" = Checker
Column "C" = Group
Column "D" = Cost per Job
(each row is a different job)
This is on worksheet "List Input"

This (below) is on worksheet "Sheet2"
End user will be able to pick which draftsman he wants to look at and all
his cost

What i need help with :
Trying to write code to look at who the end user wants to look at, and
display all the jobs that he's worked on.

Example :
End user picked "EB"
On the "List Input" page, the code will look down column "A". Everytime it
sees "EB", it copies the entire row, and places it in a specific range of
cells on "Sheet2". Once it has checked all in column "A", it stops.

Can anyone help me please ?
Thanks,
Eric