Microsoft Office Forums - View Single Post - How to perform summary calculations in multiple worksheets, merged cell format and new product issue

leeqiang · 09-26-2020, 11:14 PM

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.