Need Help Creating A Macro
 

I have a spreadsheet with 8400 lines of products offered by my company. I
need to break these products into their divisions and send them out to the
respective sales managers.

I have column headers for Product Code, Product Description, and then each
division's Price and Availability. Unfortunately, information is not in
every cell, except for its product number and desciption. The sales managers
have around 400-600 items that they manage that are not sequential.

What is the best way to delete the other material and send on just their
product numbers?

Hi

The autofilter should be of great help:
http://www.contextures.com/xlautofilter01.html

See also the advanced Filter for extracting data:
http://www.contextures.com/xladvfilter01.html

HTH. best wishes Harald

"LJ Owen" <LJ skrev i melding
...
I have a spreadsheet with 8400 lines of products offered by my company. I
need to break these products into their divisions and send them out to the
respective sales managers.

I have column headers for Product Code, Product Description, and then each
division's Price and Availability. Unfortunately, information is not in
every cell, except for its product number and desciption. The sales
managers
have around 400-600 items that they manage that are not sequential.

What is the best way to delete the other material and send on just their
product numbers?