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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Euro Crisis? 1
Consolidate / pivot challenge 2
Macro to work list in filter and save 1
Macro to work list in filter and save (reposted from MPE misc) 4
using part of a cell to sort a list into groups 2
Summing a ranking of several categories 4
Need macro to drag values down to blank cells 3
Address selection on combo box help 2

Back
Top