Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
............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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
loop code error help!!!! | Excel Discussion (Misc queries) | |||
Loop for VBA code? | Excel Worksheet Functions | |||
How to Loop some code | Excel Discussion (Misc queries) | |||
VB for excel, how do I loop through code | Excel Discussion (Misc queries) | |||
VBA Newbie: Help with Do Loop code | Excel Discussion (Misc queries) |