Macro and filtering

drag-driver · May 22nd, 2002, 08:52 AM

Problem:In colum A i have id codes for a product such as G123456,g654321. These codes can be anyvalue. I want to use the filter and a macro to step true all the products in that colum so that i can alter the data in the other colums adjacent as required. How do i get my program code to select individualy each product in the filter, if the products where the same every time i would just tell it to select that product but since thier ids can be anything whats the solution..

thanks for the help

Thomas

sann0638 · May 22nd, 2002, 09:03 AM

thomas,
if all the ids are different, why do you want to filter them? if some are repeated, you could have a master vlookup table.

May 22nd, 2002, 09:03 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	thomas, if all the ids are different, why do you want to filter them? if some are repeated, you could have a master vlookup table. __________________ Regards, Mike.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 08:52 AM	#1
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	Problem:In colum A i have id codes for a product such as G123456,g654321. These codes can be anyvalue. I want to use the filter and a macro to step true all the products in that colum so that i can alter the data in the other colums adjacent as required. How do i get my program code to select individualy each product in the filter, if the products where the same every time i would just tell it to select that product but since thier ids can be anything whats the solution.. thanks for the help Thomas