See attached macro.
For the "ConcCols" array, can it be coded it so that it only shows unique values in the concatenated column? (should the same piece of equipment be listed twice for the same person).
See attached macro.
For the "ConcCols" array, can it be coded it so that it only shows unique values in the concatenated column? (should the same piece of equipment be listed twice for the same person).
See.........
Is it possible to alter this code so that it compares values from two worksheets e.g.
- Find duplicates, conccatenate, sum values, and delete duplicates in worksheet
- Then find duplicates, sum values, and delete duplicates in another workbook
- And finally subtract matched items ( worksheet1 - worksheet2 = worksheet3)
Aorusakwe
You need to open your own thread by the rule.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks