One other approach, assuming your data caters for it, is to hold a
code for the level of VAT against each product.

e.g. Product A (standard rate) code TS
Product B (zero rated) code T0
product C (Exempt VAT) TE
Product D (Reduced Rate) TR

Then when your macro copies the product, if it also copied the VAT
code, your VAT calculation formula could be made to be automatic by
using a lookup of the VAT code in a simple VAT rate table.

If you don't want to carry an extra field for VAT, you might like to
consider building the VAT code in with the Product name or code.

e.g. Product A (TS)

then use some string slicing in the VAT formula to identify the two
character VAT code.

HTH


On Wed, 6 Sep 2006 07:09:03 -0700, triffidbook
wrote:

I am using a spreadsheet which uses a macro to copy and pasted products onto
a selected area on the same worksheet. One of the items requires 0 VAT. Is
there anyway this can be achieved when the item could appear in one of 46
rows, it is always the last item to be shown on the pasted list, although it
is dependant on what is pasted above it as to which row it will be pasted.

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________