Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-26-2020, 10:50 PM
leeqiang leeqiang is offline How to perform summary calculations in multiple worksheets, merged cell format and new product issue Windows 10 How to perform summary calculations in multiple worksheets, merged cell format and new product issue Office 2019
Advanced Beginner
How to perform summary calculations in multiple worksheets, merged cell format and new product issue
 
Join Date: Aug 2020
Posts: 53
leeqiang is on a distinguished road
Default How to perform summary calculations in multiple worksheets, merged cell format and new product issue

How to perform multi-table summary calculation
1. Worksheet name: There is a summary of the data, the total amount in 2020, the total loan in 2020, and the 12-month schedule of each year are January to December details.

2. Worksheet format: The format of the detailed table from January to December is unified, and the detailed worksheet of the current month will be added as the month progresses. The header of the monthly schedule starts from the second row and lists each product name. The product name occupies three cells in the same industry and has been merged together. This product name corresponds to the three cells in the next row. It is the number of pieces, quantity and loan. The number of rows in the table data area is the number of days included in the current month, and the last row of the table corresponds to the summary of the corresponding data for the month. That is, the sum of the number, quantity, and loan of each product.



3. Requirements: According to the same products in the monthly schedule, the total quantity worksheet for 2020 summarizes the monthly quantity of the corresponding products in all the detailed worksheets, and summarizes the product's current year in the last line The total number. In the 2020 total loan worksheet, summarize the monthly loans of the corresponding products in all the detailed worksheets, and summarize the total loans for this year of the product in the last line. Among them, the completion of the schedule is an annual process. If there is no schedule for the month, the summary of the month in the summary table is displayed as blank or 0. When a new product is inserted into the product row in the schedule for a certain month, run During the program, the product is automatically added to the product line in the two quantity and loan summary tables and the corresponding quantity is summarized. The other month schedule does not include the product in the corresponding month of the summary table. The number is displayed as 0.


the total.xlsm
Reply With Quote
  #2  
Old 09-26-2020, 11:14 PM
leeqiang leeqiang is offline How to perform summary calculations in multiple worksheets, merged cell format and new product issue Windows 10 How to perform summary calculations in multiple worksheets, merged cell format and new product issue Office 2019
Advanced Beginner
How to perform summary calculations in multiple worksheets, merged cell format and new product issue
 
Join Date: Aug 2020
Posts: 53
leeqiang is on a distinguished road
Default

Question 1: How to automatically scan and regenerate the products in each detailed table into two summary tables?
When a new product name appears in a certain month, it is necessary to add the new product name to the header of the summary table and summarize the corresponding data.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to perform summary calculations in multiple worksheets, merged cell format and new product issue How to unmerge all merged cell and fill them with the merged values? Bumba Excel Programming 1 11-10-2019 11:36 AM
How do I perform simple mathematical calculations on numbers in the text pelagic Word 2 04-08-2014 05:10 AM
Excel Multiple Rows Merged into Word (Vertical Format) ats1025 Mail Merge 3 11-19-2013 02:21 PM
How to perform summary calculations in multiple worksheets, merged cell format and new product issue Sum multiple worksheets and summary tab that would sum and count by rep name angie.chang Excel 1 05-16-2013 12:36 AM
How to perform summary calculations in multiple worksheets, merged cell format and new product issue Perform Calculations using List boxes Jennifer_Falcon Word VBA 6 07-26-2011 10:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft