Excel 2010 - Matching Part Codes with Prices on different workbook (or sheets in same WB)
Source Workbook contains 1 sheet with 2 columns, Column A (Part Number) & Column B (Price)
Target Workbook contains 1 sheet with 2 column, Column A (Part Number & Column B (Source Price)
It is quite possible that Source WB will contain additional entries in column A that do not yet appear in column A of Target WB.
How do I program it that if there is a match between any Source Column A and Target Column A then grab the price from Source column B and put it in Target Column B where the Column A Source Part code matches the Target Column A Part code.
Also. I need to deal with entries that appear in Source Column A that do not yet appear in the Target Column A
Thanks
ASKER
Above should have been
**Which seems to work, however it does notw let me know................
Sorry
**Which seems to work, however it does notw let me know................
Sorry
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your assistance in both entries patrickab.
I will apply both and see how I go. I guess I should get a book on Excel 2010. Any recommendations would be great. I was thinking about Excel 2010 Inside Out when it is released. Thoughts?
I will apply both and see how I go. I guess I should get a book on Excel 2010. Any recommendations would be great. I was thinking about Excel 2010 Inside Out when it is released. Thoughts?
ASKER
I do have one question for you though. in your code you have placed the word 'celle', is that a typo??? I ask because it does not feature in the Excel or VB help file
NorthstarIT,
>I guess I should get a book on Excel 2010. Any recommendations would be great.
I have no experience of Excel 2010 as I'm a user of Excel 2002! I rely on several books but the best VFM is 'Excel programming for Dummies' by John Walkenbach. Don't be put off by the title. That is a better book that the one he wrote earlier as the index in his more expensive earlier book it utterly pathetic to the point of serious annoyance. So I'd care to guess there's a 2010 edition - see:
http://www.amazon.co.uk/Excel-VBA-Programming-Dummies-Computers/dp/0470503696/ref=sr_1_8?s=books&ie=UTF8&qid=1281716067&sr=1-8
for example.
Patrick
>I guess I should get a book on Excel 2010. Any recommendations would be great.
I have no experience of Excel 2010 as I'm a user of Excel 2002! I rely on several books but the best VFM is 'Excel programming for Dummies' by John Walkenbach. Don't be put off by the title. That is a better book that the one he wrote earlier as the index in his more expensive earlier book it utterly pathetic to the point of serious annoyance. So I'd care to guess there's a 2010 edition - see:
http://www.amazon.co.uk/Excel-VBA-Programming-Dummies-Computers/dp/0470503696/ref=sr_1_8?s=books&ie=UTF8&qid=1281716067&sr=1-8
for example.
Patrick
NorthstarIT,
BTW, as a Premium Service Member why do you offer such a pathetically low number of points for a question? You do know, surely, that you can ask as many questions as you like and offer up to 500 points for any question. It'll grab the attention of experts that much faster - believe me.
Patrick
BTW, as a Premium Service Member why do you offer such a pathetically low number of points for a question? You do know, surely, that you can ask as many questions as you like and offer up to 500 points for any question. It'll grab the attention of experts that much faster - believe me.
Patrick
ASKER
Fair point. I was just sort of warding points on the severity of my problem and how quickly I wanted it answered. Perhaps I am being too tight.
How many points can I use like in a month etc?
How many points can I use like in a month etc?
ASKER
Sorry, mis-read your last post. I will dish many more pointsd from this moment on. The next question I am about to ask about Excel will have 500 points, I promise
>How many points can I use like in a month etc?
You have no limit as you're a Premium Service Member.
You have no limit as you're a Premium Service Member.
ASKER
Thanks Patrick. As I said, the next question I have about Excel which I will be asking later will have 500 points attached, I promise
>I do have one question for you though. in your code you have placed the word 'celle', is that a typo??? I ask because it does not feature in the Excel or VB help file
Sorry I missed that question. I use celle as it is a variable defined by me and cannot be confused with any VBA protected words and is distinctly different to Cells. Some people do use cell as a name for a variable but to me that looks even more like a VBA protected word so I always use celle. Mind you I could just as easily have used variable named 'patrickscell' or whatever I chose.
Patrick
Sorry I missed that question. I use celle as it is a variable defined by me and cannot be confused with any VBA protected words and is distinctly different to Cells. Some people do use cell as a name for a variable but to me that looks even more like a VBA protected word so I always use celle. Mind you I could just as easily have used variable named 'patrickscell' or whatever I chose.
Patrick
>As I said, the next question I have about Excel which I will be asking later will have 500 points attached, I promise
You watch, the other experts will be all over it like a swarm of bees!
Patrick
You watch, the other experts will be all over it like a swarm of bees!
Patrick
ASKER
=VLOOKUP(A:A,Source!A:B,2,
Which seems to work, however it doesw let me know of entries in source that do not appear in target
Would that be a conditional formatting thing?