N
N1KO
Hi All,
This is probably easy but.
Due to the possibility that the VAT rate may change from 17.5% to 15% i need
to change a lot of prices.
All the prices in my sheet are inclusive of VAT, I need to find the VAT
amount, then find the price without VAT and then find the price of adding the
new VAT amount on to it.
I know how to do this with simple formulas on the sheet but i need to create
some vba code so i can run it in various workbooks.
Currently i have this in the cells.
A1 - £49.00 - price
B1 - =A1*7/47 - to get the VAT amount
C1 - =A1-B1 - price without VAT
D1 - =C1+15%
I can do the loops and stuff to run it down the sheet i just need the code
to allow all these details to be automatically entered as it goes down the
rows.
If anyone has any ideas about how i could find this that would be appreciated.
This is probably easy but.
Due to the possibility that the VAT rate may change from 17.5% to 15% i need
to change a lot of prices.
All the prices in my sheet are inclusive of VAT, I need to find the VAT
amount, then find the price without VAT and then find the price of adding the
new VAT amount on to it.
I know how to do this with simple formulas on the sheet but i need to create
some vba code so i can run it in various workbooks.
Currently i have this in the cells.
A1 - £49.00 - price
B1 - =A1*7/47 - to get the VAT amount
C1 - =A1-B1 - price without VAT
D1 - =C1+15%
I can do the loops and stuff to run it down the sheet i just need the code
to allow all these details to be automatically entered as it goes down the
rows.
If anyone has any ideas about how i could find this that would be appreciated.