Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal with tax
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal with tax
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal with tax
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal with tax
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal with tax
I would set it up so that all you do is press a button.
"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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal with tax
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal with tax
With a few changes you could use this. If you would send my the workbook I
could get you started. Its up to you. Private Sub getDataFromAccess() 'Needs reference the Axtive X Library 2.0 or higher Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Dim sSQL As String, strConn Dim rowNumber As Long 'C:\PathToYourMdb\Ilsa.mdb (Change) strConn = "Provider=Microsoft.Jet.OLEDB.4.0; " & _ "Data Source=C:\PathToYourMdb\Ilsa.mdb;Persist Security Info=False" 'sSQL = "Replace with your query" sSQL = "SELECT Field1, Field2 From TableName" Set cnn = New ADODB.Connection Set rs = New ADODB.Recordset cnn.Open strConn rs.Open sSQL, cnn, adOpenStatic, adLockOptimistic rowNumber = 2 'Starting Row Number for data Do While (Not rs.EOF) Range("A" & rowNumber) = rs.Fields("Field1").Value Range("B" & rowNumber) = rs.Fields("Field2").Value rowNumber = rowNumber + 1 rs.MoveNext Loop rs.Close Set rs = Nothing cnn.Close Set cnn = Nothing End Sub "Renee" wrote: 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? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal with tax
Wow, that sounds like it would take some time for me to figure out how to do.
I will have to look into it for later. For now can you help me with the code for when the query is exported to excel? "Mike" wrote: I would set it up so that all you do is press a button. "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? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal with tax
I can but trust me it would be easier for me if you send me a copy of the
workbook. "Renee" wrote: Wow, that sounds like it would take some time for me to figure out how to do. I will have to look into it for later. For now can you help me with the code for when the query is exported to excel? "Mike" wrote: I would set it up so that all you do is press a button. "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? |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal with tax
But then how do I do it for the rest of the time? As I would need to do this
once a week. "Mike" wrote: I can but trust me it would be easier for me if you send me a copy of the workbook. "Renee" wrote: Wow, that sounds like it would take some time for me to figure out how to do. I will have to look into it for later. For now can you help me with the code for when the query is exported to excel? "Mike" wrote: I would set it up so that all you do is press a button. "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? |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal with tax
I could set it up to pull in the data from the workbook that was exported
from access Press the button and it will run. "Renee" wrote: But then how do I do it for the rest of the time? As I would need to do this once a week. "Mike" wrote: I can but trust me it would be easier for me if you send me a copy of the workbook. "Renee" wrote: Wow, that sounds like it would take some time for me to figure out how to do. I will have to look into it for later. For now can you help me with the code for when the query is exported to excel? "Mike" wrote: I would set it up so that all you do is press a button. "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? |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal with tax
How do I go about sending you a copy of the workbook?
"Mike" wrote: I could set it up to pull in the data from the workbook that was exported from access Press the button and it will run. "Renee" wrote: But then how do I do it for the rest of the time? As I would need to do this once a week. "Mike" wrote: I can but trust me it would be easier for me if you send me a copy of the workbook. "Renee" wrote: Wow, that sounds like it would take some time for me to figure out how to do. I will have to look into it for later. For now can you help me with the code for when the query is exported to excel? "Mike" wrote: I would set it up so that all you do is press a button. "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? |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal with tax
There, email is sent from
"Mike" wrote: Send to "Renee" wrote: How do I go about sending you a copy of the workbook? "Mike" wrote: I could set it up to pull in the data from the workbook that was exported from access Press the button and it will run. "Renee" wrote: But then how do I do it for the rest of the time? As I would need to do this once a week. "Mike" wrote: I can but trust me it would be easier for me if you send me a copy of the workbook. "Renee" wrote: Wow, that sounds like it would take some time for me to figure out how to do. I will have to look into it for later. For now can you help me with the code for when the query is exported to excel? "Mike" wrote: I would set it up so that all you do is press a button. "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro excel subtotal in subtotal | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |