- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
1. Find the copy of the workbook on which you will merge the changes. In Excel, go to "File > Open" and find the file.
3. Click "Tools > Compare" and "Merge Workbooks."
4. Look for the files you want to merge and add them into the current file.
5. Click “OK” to merge the files. This is your master copy of this workbook.
6. Save the file.
You need to create subtotals so that it looks like something like this:
Prod/units Amt. Level Total
xxxx 10.00 1 yyyy 20.00 1 30.00
dddd 40.00 2 ffff 30.00 2 70.00
To do this I would suggest using the Pivot Table feature of Excel. It is not too hard to use but you do have to know what you want and also have to be sure you are getting results as expected. Like any tool, it has to be used right. You can also use sub-total functions supplied in VBA as well in your cells.
If you want to avoid using VBA functions in cell and deal with ranges, etc., use the Pivot Table Wizard.
Some reading: http://www.ehow.com/how_13020_pivot-table-wizard.html http://www.microsoft.com/dynamics/using/excel_pivot_tables_collins.mspx http://www.ozgrid.com/Excel/excel-pivot-tables.htm
Also Google "Excel pivot table wizard" to get more.
I do this on a routine basis. In Access select the table or query that you want to convert to Excel. Then File, Export, You then will see a Dialog Box that allows you to select the format and file name.
That procedure can also be performed using Access Macros for an automated solution.