VBA uniques from multiple columns then manipulate data

[elfina]

Hello folks,
I am always glad to be here. I have learned so much from you guys.
Today, I am bringing a project and I need a big help. FILE IS ATTACHED.

I need an excel or vba macro to do this.

Consolidate the list of items in columns (A, C, E…;Z) Always skip 1 column since Date column follows the securities
Consolidate all securities in 1 column, removing duplicates.

The big issue is that the security list change on daily basis, new addition, removal etc

The result should be 1 columns for all securities and several columns for the dates and corresponding rates: 1 for all securities and the second for dates.

Thanks million.
Elf.

[jaslake]

Hi elfina

Welcome to the Forum!!!

This Code in the attached appears to work for GOAL-1. CTRL + x will fire the Code.
I'll have to think on GOAL-2.

Please Login or Register  to view this content.

[elfina]

jaslake

Works like magic for Goal-1. Thank you so much.
I was able to edit further to adapt to my needs.
Thanks again,
Elf

[jaslake]

Hi Elf


Glad it works for Goal-1. This concerns me a bit as I'm working on Goal-2...Goal-2 is dependent on Goal-1...what adaptations were required?

I was able to edit further to adapt to my needs.

[jaslake]

Hi Elf

Code has been added in the attached to accommodate Goal-2.

For the initial set up of Goal-2, run Goal_1 Code first...CTRL + x

[elfina]

jaslake

Not a big concern, its only formatting updates. it will not create any issues on current and/or further addition of coding.
Thanks again,
Elf

[jaslake]

Hi Elf

I don't know what this means...

its only formatting updates. it will not create any issues on current and/or further addition of coding

Please post an example so I can SEE what you're referring to. Include Code in the example so I can recreate the issue.

[elfina]

Jaslake - sorry for late reply, business trip.
I meant to say I did some minor changes to your original code. The changes won't affect further addition. I was saying this in case you are building Gaol-2 from your original code.
Thanks again,
Elf.

[jaslake]

Hi Elf

As long as it works for you.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.