macro help

  • Thread starter Thread starter H.Schurch
  • Start date Start date
H

H.Schurch

Dear Experts

I have three salesmen that have to visit certain towns every year. The names
of the towns are in cells B50: B112. The name of the visiting salesman is in
the same row in column M. The year of the visit can be selected in cell C3
via a drop down box.

I would like to create a macro that would lookup the name of the salesman,
in Cell C6 select all the towns that are allocated to this salesman and copy
the list of towns and paste the result to a new worksheet without any empty
cells in between towns.

Any help greatly appreciated
 
A macro is not required for the functionality. Data|Filter|Auto Filter
then select a salesman's name from the pick list for column M, and copy
from column B.

If you really want a macro, record it while you do the Auto Filter, and
modify it to accept inputs.

Jerry
 
Back
Top