|
|
#4
07-15-2017, 10:13 PM
|
|||
|
|||
A VBA option.
No need for anything on the SAMPLE sheet other than the original ID;AMOUNT range. The ID list and TOTALS are recalculated and written to columns M:N each time the command button is clicked. 
|
| Tags |
| inventory, sum, vba |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Need Excel to recognize week numbers based on specific dates
|
Ktyler | Excel | 5 | 02-06-2017 11:08 AM |
| Open a document based on a template, the page numbers in the TOC won't update | billy8b8 | Word | 2 | 10-04-2015 06:06 AM |
| Search a cell that contains words and numbers and convert the numbers to metric | Carchee | Excel Programming | 36 | 10-08-2014 03:16 PM |
| How do I refer to page numbers, when the numbers change as I prepare the document? | StevenD | Word | 5 | 11-29-2012 12:52 AM |
| Create index based on bullet numbers | EZRider | Word | 0 | 07-10-2009 09:21 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode