It might be a very simple question, but i am totally stuck with this problem. What i have is 3 worksheets in excel
this is the data sheet with fields
a1 customer name
b1 monthly premium
c1 agent number.........and so on.
a1 agent number
b1 agent name
c1 agent address.........and so on.
what i want to do here is put an agent number in A1 let us assume "60"
then a macro runs through the colomn c of sheet 1, and if a customer exists has an agent number= 60, then starting at row 5 in sheet 3 starts to copy the customer name and his monthly premium one by one from sheet 1.
for instance if there are total 3 customer that have agent 60 in sheet 1, at row 14, 27,and 59 respectively. Then in sheet 3 all i want is 3 rows with customer that had that number 60 in their c coloum (i-e rows 14,27and 59).
any thing or clue will help, i am just a dumb node, please help