Hello again,
As soon as I have a moment ... will look into your latest concern ...
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
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
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