Posted: Mon Feb 23, 2009 10:37 am Post subject: If Cell Value Problem
I have a major project on the go and I'm a bit stuck with it.
What I am trying to do, is, we have many cartridges (asin Ink Carts).
As you probably would have guessed there's loads of cartridges that are compatibe with printers.
I have made an update list of what cartridge is compatible with which printer.
What I was therefore wanting this macro to do, was to:
Look down the list of productcodes.
Find the same code in another sheet, then move over to the manufactuer of that cartridge, save it as a variable say manufacturer (only for an example) and printer then move over to the printer model it works with and save that maybe as a variable? and then copy that over to the original sheet with a prefix between the manufactuer and model of printer with a '/', as that is what our import system requires to seperate categories to sub categories.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum