Anthony's VBA Forum Index Anthony's VBA Forum
Where the knowledge is shared
Menu
 Anthony's VBA Forum IndexHome Page
 Anthony's VBA Forum IndexForum Index
FAQFAQ
MemberlistMemberlist
UsergroupsUsergroups
RegisterRegister
ProfileProfile
Log in to check your private messagesMessages
Log inLogin/Out

Quick Search

Advanced Search

Links
Consulting
Products

Who's Online
[ Administrator ]
[ Moderator ]


If Cell Value Problem

 
Post new topic   Reply to topic     Anthony's VBA Forum Index -> General Excel VBA
View previous topic :: View next topic  
Author Message
j.smith1981



Joined: 23 Feb 2009
Posts: 2

PostPosted: Mon Feb 23, 2009 10:37 am    Post subject: If Cell Value Problem Reply with quote

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.

Could someone help me make this work?

I am out of ideas as to how to acheive this.

Thanks in advance,
Jeremy
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic     Anthony's VBA Forum Index -> General Excel VBA All times are GMT - 4 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2002 phpBB Group