vat

Hi I am in the UK and analysing data for VAT purposes and want to produce a report with all transactions which show the VAT % of more than 21% less than 19% but not 0%. The data I will have is as below Column A (name) Column B (VAT %) Dave 21% Bill...

Hi Really new to VBA and Macro's so any help would be much appreciated :eeek: I have a spreadsheet that contains data that needs to be pasted to a different worksheet depending on cell value. For instance: <colgroup><col width="116" style="width: 87pt; mso-width-source: userset...

Im doing someones accounts and i need to use the IF FORMULA to work out the values, so between if there wage is between £5000 and £45000 that week (lets say) i want there wages to be charged at 7.5% VAT and it works out the values for me. So when it goes over £45+k i want it to be charged at 20%...

Hi all, I have found this code here a few years ago, and for some reason it is not working "very well" anymore. I am not sure if it is the website returning bad data, or something else: Public Function VAT(rng As Range) As String With CreateObject("MSXML2.XMLHTTP") .Open "GET"...

Hi every one, Ive been glued to this forum for seval hours now, reading older posts, but Im going to admit defeat before my brain explodes!! OK so Im a novice with excel, but I dont want to be beaten! Also before answering, can you help me by just keeping it simple, and basing it on 100-20%...

Hi Guys, I hope someone can help me with this query! I have a badly written database to fix, I have invoice generating queries that contain the code VAT: IIf([VAT Applicable]=True,[Amount]*0.175,0) If i simply change all of the queries to 15% the historical data will be affected, so I need...