I use an array to traverse the monthly worksheet summaries in the workbook, why the display types do

		Microsoft Office Forums > Microsoft Excel > Excel Programming
I use an array to traverse the monthly worksheet summaries in the workbook, why the display types do

FAQ

Thread Tools

Display Modes

#12

10-07-2020, 09:18 PM

leeqiang

Windows 10 I use an array to traverse the monthly worksheet summaries in the workbook, why the display types do

Office 2019

Advanced Beginner

Join Date: Aug 2020

Posts: 49

Quote:

Originally Posted by Purfleet

Sorry i didnt see the Sum worksheet embedded in the first post (its normally at the bottom of the post)

So you just want the sum of Price quantity and freight?

First tip - dont merge cells, they will play havoc with formulas and vba

yes,sum of Price, quantity and freight.
merge cells in order to input the title of table.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I copy a worksheet and paste values to another new workbook ?	DBenz	Excel	1	01-26-2019 07:03 AM
Sharing a Workbook that contains array formula link to other workbook	Ahmad.rage22@gmail.com	Excel	0	03-12-2018 10:15 PM
Outlook 2016 calendar monthly display	Herbert	Outlook	0	09-22-2017 04:41 AM
How do I populate Worksheets using information entirely from another Worksheet in the same Workbook?	BrieDanielle	Excel	1	06-18-2016 10:50 AM
Counting unique visitors by ward, counting monthly visits by status, editing existing workbook	JaxV	Excel	9	11-14-2014 12:25 AM