Update Values by a Percentage using VBA

[NickPDC]

Hi there guys,

I was hoping the community would be able to help me out a bit here.

I have a Workbook (attached), where the data within, is copied and pasted from an external source.

This data then needs to be updated with any price changes that may occur, this is the "Contract Price" in the O column.

This needs to be updateable by putting a percentage into the Increase Percent box at B4.

Say you have a contract price of £10, and you wanted up update this by 20%, would give the result of £12, and so on.

The "New Effective Date" value will also need to be pasted into the "Effective Date" column for the data.

The twist is this..

There is a drop down box at B6. This is basically needed to allocate the price change to a certain area of manufacture. Eg, Scrap Metal Surcharge etc.

So the Macro will need to calculate 20% of the "Contract Price", and then paste the percentage value increase, into the corresponding column (located between columns R and V).

If a percentage increase occurs, it occurs to the entire range, so the entire range of values will need up be updated, with their corresponding price changes.

The second worksheet is the price per Kg.

This is slightly harder, where the "Contract Price" is the price the customer pays per Kg of product.

If there is a price increase of £2 per Kg across the range, then £2 will need to be added to each of the "Contract Prices", but this will also need to be allocated to the value in the drop down box at "B6".

I hope this makes sense, and that someone will be able to help me out!

Cheers,

Nick