Excel VBA: Count Part Numbers which are the same and be able to replace the price all of

1)
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

2)
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hello,

Thanks I reedit my post!

Thanks for the edit.

I don't understand what you are trying to do.
Can you upload a workbook with before/after clearly showing the logic behind it?

Can you open the workbook which I uploaded?
If so then the "Konfig" Sheet contains the price quotation which i send out to my clients (I have VBA codes to generate this and codes to export it to pdf so the user only sees what they need, which is column B-G range).
On the column B there is the "part number" while column C contains the name and the E is the price of that part excepet the rows which contains the "PCT Blade" name, the price in these rows are the sum of the parts below.
My problem is if I want to change one of the parts prices for example this (Row10):
SZGRK-PC1HDD1_A-170322 500GB 3,5" HDD belső merevlemez 1 11 163 Ft

If I change the 11.163 Ft to something else, like 10.000 Ft, than after this I need to manually looking for all the same part number "SZGRK-PC1HDD1_A-170322" becouse the same part numbers cannot have different prices when I sent this out. If the same part number has different price than my price quotation is wrong and I will be disqualified from the competition. (i cannot find the proper english word, but hope its understandable.
So this part number is again in Row 24, and in row24 I need to manually change the price to be also 10.000. In this case its not a big deal, but there are times when this list is quite a few hundred lines whit lots of similar part numbers everywhere and looking and chaning manually its a really painful job.
I'm thinking about a listbox or combobox, that appears after a button is pushed, and that gives meg something like this
Part Number
SZGRK-PC1HDD1_A-170322 occurs 8 times current price "11.163" The New Price? "input"
SZGRK-PC1RAM1_A-170322 occurs 3 times current price "9.086" New Price? "Input"
and when I hit okay it changes all in the worksheet.
So this is understandable what I would like to do?

Maybe it can be done easier with Sub Worksheet_Change which is looking the price column and after that is changed its looking for the same part number and offer an inpubox to change to the same price. Im thinking.

So Col.C is nothing to do with the change?

This is how I understand...

If you change one of the price in Col.E for particular Part# in Col.B, the price(s) of the same Part# should change to the same.

Is that correct?

If you want above, add bold part to your existing code.

Please Login or Register  to view this content.

Yeah that is correct. No, its nothing to do with column C, only the price is the vital part.

Wow thank you this code has it
But my mistake, the price what is changeing is in the J column, and not in the e (The E is calulating from the J).
So everything is the same, but the J is the changeing column. I try to replace the code to work that way. (What is a8. before the currentregion?

OK
Change to

Please Login or Register  to view this content.

A M A Z I N G !
Thank you for your help, works like charm!

That's good.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.