For tax purposes I need to show my accountant the subtotal and tax amount in a separate column. My first worksheet is my invoice, and the second is my register which pulls data from the invoice.'Range.copy to other worksheets. I'm using the following which works for the subtotal, but I need it to work for each invoice and not just one, so my range I think is wrong. I also cannot get the tax amount to work using a similar formula. What formula should I use for the tax? The attachment option is not working.
Worksheets("Invoice").Range("D31").Copy Worksheets("Register").Range("F4")
Bookmarks