Assistance with price update

[ragan.anthony]

I am having problems with an excel sheet.
Previously, the sheet was seperated into tabs for each individual school, but the higher ups decided it was better to keep it all one one sheet.
My VBA is set up still for the tabbed page. I can still run the macro and create a master list of all my items, that works perfectly. the problem I am running into is when i key in a price on the master list, it does not populate for every school. Only the first and maybe the second. Items further on down never populate and I am thinking it might be because it was set up for each tab previously.

So what I need is to enter a price on the "MASTER LISTING" sheet and it populate the price on the other sheet for each entry of that item (which is sometimes every school).

Any assistance would be awesome. I have attached the sheet.

Thanks!

EDIT: I had to actually remove quite a few entries on the first sheet. About 12000 lines actually due to the size (couldn't upload over 1 MB.

AnthonySHEET update.xlsm

[daffodil11]

Digging through it currently!

[daffodil11]

Cool. Think I got the kinks all worked out.

First, we can remove the For Each ws because we're only targeting a single worksheet. While we are at it, we can specify that worksheet.

Next, we change the comparison expression to a string, because the Product Codes on NEWDE3 are all text even if they are number, so we make sure that the codes on the Master List are converted to text for purposes of comparison.

Lastly, we remove that Exit For. This was intentionally ending the loop early because in your old version there was only a single listing per tab and we wanted to stop searching once we found one.

Please Login or Register  to view this content.

[ragan.anthony]

Beautiful! Works perfect! I have actually been reading and learning on my own. Just was getting stumped, but I see now where I was going wrong.
Thanks again!!

[daffodil11]

You've really come a long way! You're doing great.