Copying data from one worksheet to another worksheet

[Drillgirl]

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")

[Olly]

To clarify: do you have multiple Invoice sheets, and want your Register sheet to be a summary of all the Invoice sheets?

[Olly]

I've just noticed your file has a "PostToRegister" sub, which almost does what you want - I'm guessing you want to amend this to also include the Sales Tax amount?

If that's the case, then simply change this line:

Please Login or Register  to view this content.

[Drillgirl]

Thank you.

[Olly]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also "Add Reputation" to those who helped you. Thanks.