Macro to Sort/Filter

Hi all,

I have a database that look like this:

A B C D E F
Date.a value.a Date.b Value.b Date.c Value.c

The dates between A C and E are not always the same. Sometimes a date is skipped in one of the colums so the lines do not match (it's not necessarly the same date on line X for a/b/c).

I want to arrive to a result like this:

G H I J
Date value.a value.b value.c

With only the dates where I have a value for all 3 columns.

As of now I do it manually trough this process:
- I add a column with all the dates (the starting and ending point is the same for all columns)
- I use a Vlookup formula to get all the values
- I delete the empty ones (N/A) using a filter.
- I rerank the range using descending dates.

I wonder If I could use a macro to do all this in one shot.

Thank you for your help!
Attached is an exerpt of the file I'm working on.

Exactly yes.

Sorry if I didn't make myself clear in the first message. English is not my first language.

Hi anassboum. Try it

Please Login or Register  to view this content.

Thanks a million nilem it is exactly what I was looking for, Thank you Friend of the Internet!!

Could you please explain in a few words what this part of the code does?

Please Login or Register  to view this content.

I adapted it to my master file and it is working as I wanted!
Thank you for you help!

Cheers!