Price change macro edit

[makinmomb]

I have this macro that does the work , now I have
a pricelist that has price at two different columns

Please Login or Register  to view this content.

[Winon]

Hello makinmomb,

Your sample Workbook contains no formulae or code, and the code you have posted does not correspond to what you have in the Workbook.

The Code you have posted will work in one column if you changed it as follow;

Please Login or Register  to view this content.

Could you explain better what it is exactly what you require? Or maybe upload a Workbook showing us what you would like to happen where and how?

Thank you.

[makinmomb]

Yes this code is for this pricelist

[makinmomb]

I want the macro to change price by 10% increase on columns F and G where there are numbers

I will feed on F5 , YELLOW shade by how much I want to increase

[Winon]

Something like this maybe?

[makinmomb]

This is good enough

I don't need buttons and you picked the wrong file
The correct file is this re attached , run and change original prices

Re attached

[makinmomb]

I don't want the price changed outside , I want it to hit where it
originally is now that is G and H

[makinmomb]

These are the prices on F AND G , look 540 is on F and not G , the macro should
smell where the numbers are

- 1,950.00
- 1,950.00
- 1,950.00
540.00 -
450.00 -
- 1,580.00

[Winon]

Thank you for the feedback.

Please see the attached Workbook.

[Vikas_Gautam]

Try this ..
with in one for loop..

Please Login or Register  to view this content.

check the attached file..

[makinmomb]

Yes Vikas this was what was needed

I want to gift my boss this , its a nice
surprise punch

[makinmomb]

Yeah Winon thanks too , yours working too as needed

[Vikas_Gautam]

Yes Vikas this was what was needed

I want to gift my boss this , its a nice
surprise punch

I am happy that I have been able to help...

Thanks for the feed back too...

[Winon]

Hello makinmomb,

Thank you for replying back, and also for adding to my Reputation.

It is much appreciated.

Glad we could help.

Regards.