Help with pricing sheet, previously (solved) but running into error.

Daffodil11 helped me immensely with my project but I am running into a problem!!

The link with original code is here http://www.excelforum.com/excel-gene...-document.html

The first code, works fine if the item of my product in the C column starts with a letter. But if it is just a number, then it doesn't work.

Example: Item number for apples is H6044 that works perfect.
Item number for grapes is 79662 this does not work.


The second question I have is he set up PERFECTLY a code that works with the largest account where if I enter prices directly into their acct, it auto populates to the other accts that have the same item number on the different sheets. But when I put that code onto the other sheets and replace the sheet name, it crashes Excel...am I doing this wrong??

Some accts order items that other accts don't so the more accts I can theoretically enter, the more and more of the sheet will populate.

Any questions or if I need to attach anythign, just let me know!!

Okay, so my document has 51 separate sheets. I would LOVE to make a master sheet as the sheets are "handed" to me all sepearately. Could I make a new sheet within the document and compile a list without having to cross reference 51 different sheets?

Edit: I say this because I have to update this document every 3 months and new items are added to the seperate accts quarterly...so if i could somehow run a code or function quarterly as I receive the separate sheets that updates, or even i could create a new master list each time so i don't miss products.

Okay, I actually think we are 95% of the way there.
I am going to attach my final product so you can take a look at what I am missing/doing wrong.

I got the Master Listing page all set up and ran the code. Everything looked fine, and I entered all the prices, but when I went to double check the
individual sheets against the Master Listing, there were products on those sheets that were not on the Master List. Quite a few, both starting with
letters and with numbers.

I am not sure if it is because of the description of the item being similar to another item. But it just seems like this is so close!!!!