I can pull the data from Access that I need? Don't think I have heard of
that. I have entered some vba code but not created my own, I am just starting
to learn how to write it.

"Mike" wrote:

It will take vba code to do this. Do you know how to write code ? If it was
me instead of exporting it from access I would have excel pull the data I
needed.



"Renee" wrote:

You can't just explain it to me, cause I am going to be exporting and doing
these totals on a weekly basis so I need to know how.

"Mike" wrote:

Yes it can
I can help if you want to send me a copy of the workbook.



"Renee" wrote:

I have a query that I export from access to excel and would like to subtotal
each invoice listed on the sheet but also include the tax and grand total of
the invoice. Is this possible?