| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro - find dups & add
I have a worksheet with columns Part and Qty. Some Parts have multiple
entries. I need a macro to find the multiple entires and sum the Qty, creating only one entry per Part. This data will then pass through a macro being copied and pasted into another table. Any help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro - find dups & add
You could use a pivot table rather than writing a macro to do it. Set it up
with part for your rows and Qty for your data. "Benjamin" wrote: I have a worksheet with columns Part and Qty. Some Parts have multiple entries. I need a macro to find the multiple entires and sum the Qty, creating only one entry per Part. This data will then pass through a macro being copied and pasted into another table. Any help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro - find dups & add
This works fine, but I would like to find a way to automate the process. I
have many worksheets to do this to. "Jason" wrote: You could use a pivot table rather than writing a macro to do it. Set it up with part for your rows and Qty for your data. "Benjamin" wrote: I have a worksheet with columns Part and Qty. Some Parts have multiple entries. I need a macro to find the multiple entires and sum the Qty, creating only one entry per Part. This data will then pass through a macro being copied and pasted into another table. Any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dups and Conditional Formating | Excel Discussion (Misc queries) | |||
| Comparing two columns for dups | Excel Discussion (Misc queries) | |||
| database - looking for dups | Excel Discussion (Misc queries) | |||
| Dups from 2 worksheets | Excel Worksheet Functions | |||
| Identifying Dups in different ranges | Excel Worksheet Functions | |||
Linear Mode
