When a collection created bring another column value into the collection

**nigelog** · 12-20-2018, 01:54 PM

A large data set is reduced to unique items for a sumif exercise. The column is column "C"

how can I change code to bring the value of each unique item (the row value) that is in Column "L"

Then output the two values to columns "P" and "S"

Any pointers appreciated

Please Login or Register  to view this content.

**Norie** · 12-20-2018, 02:22 PM

Try this.

Please Login or Register  to view this content.

**nigelog** · 12-20-2018, 03:10 PM

Hi Norie, I've had to go out. I'll check first thing tomorrow. Many thanks

**mjr veverka** · 12-20-2018, 03:36 PM

Please Login or Register  to view this content.

**nigelog** · 12-21-2018, 04:33 AM

Both differing methods work perfectly, thank you for your help

When a collection created bring another column value into the collection

LinkBack

Thread Tools

Rate This Thread

Display

When a collection created bring another column value into the collection

Re: When a collection created bring another column value into the collection

Re: When a collection created bring another column value into the collection

Re: When a collection created bring another column value into the collection

Re: When a collection created bring another column value into the collection

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Jagged dictionary or collection filled via variables

Dictionary vs Collection Speed

Dictionary/Collection/Other for XML/API Table Upload

2010 VBA - Ordered by Collection or Scripting.Dictionary

Collection vs Dictionary

Limitation of collection and dictionary datatype

[SOLVED] Button not bring up Macro I created

Bookmarks

Bookmarks

Posting Permissions