Posts by Carim

Hello again,

As soon as I have a moment ... will look into your latest concern ...

Great ...!!!

Thanks a lot for your Thanks ...AND for the Like

This topic has already been dealt with in many different instances ...

As an example : Consolidating different files into one main excel worksheet

Also, another example ... Mumps has written a generic solution you can adapt : Copy data from Multiple workbooks into One

Hope this will help

You are welcome

Most probably, Sam will directly answer your post

Cheers

Quote from digitalricho

When sending me the file earlier, you could have mentioned in the reply that the column C was a double-check and didnt stand a role in the formula.

So in that case, your solution was perfect!

Thank you again

You are absolutely right !!!

Sorry for not having properly and fully explained the proposed solution

You are very welcome

Regarding your desire to learn macros ... there is a wealth of resources available ...

1. If you are looking for a web site : https://www.excel-easy.com/vba.html

or a more interactive concept : https://www.automateexcel.com/learn-vba-tutorial/#vba-basics

2. If you are looking for a YouTube video :

3. If you are looking for the BEST book : Author: John Walkenbach Excel VBA Programming for dummies - A TRUE LEGEND !!!

Hope this will help

Glad to hear you could solve your problem

Column C was only shown to let you see your formula and double-check the result

Thanks for your Thanks

Thanks for the Like

Hello,

Attached is a copy of your test file ...

Is adding a second key the answer to your initial question ...?

Hope this will help

Hello,

Once you have tested the formula ... feel free to share your comments

Should you spot some other bug ... do not hesitate to let me know

Hello Mumps

You are 100% right ... !!!

Will relay your question to the Administrator : Sam ...

Cheers

Sorry for that ...

Copied the code and missed a ' +1' ...

Attached is the correction ...

Hope everything is fine

Hello and Welcome to the Forum

There are many possibilities to build a solution ...

Depending on the Excel version you are using, the simplest is to use Power Query

see https://www.myexcelonline.com/…kbooks-using-power-query/

Hope this will help

Hello,

When it comes to using Excel charts for technical analysis, there is a wealth of various resources available on the net, mainly for traders

e.g. https://marketxls.com/technical-indicators/

Hope this will help

Hello again,

Not sure to fully understand your latest remark ...

If you need to automate Excel from PowerPoint ... it is a totally different issue !!!

For your info, see following:

https://www.rdpslides.com/pptf…rom_Excel-_And_so_on-.htm

Hope this will help

Great News ...!!!

Thanks a lot for both ... your Thanks ... AND for the Like

Attached is your version 4 test file ...

Have added a condition ... to avoid the same month to be copied several times ...

Hope this will help

Quote from fi1808

That is exactly what I wanted, and you modified it beautifully.

Thank you so much.

Glad to hear it is in line with your expectations

Thanks for your Thanks

Have a look at the Version 3 test file ...

and let me have your comments ...

Hope this will help