• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Interesting/Useful _VBA/Excel links over the internet

Deepak

Excel Ninja
Dear readers,

Under the subject, i will share what's i find useful or important for me or someone's. You are also welcome to share the thing under the hood which would be useful at par.

Pls be noted that, only subject links will be entertained & rest others would be flushed without any delay.


Starting with...

A lot's of explanation about copy-paste of range in excel, this will surely useful for beginners...

http://powerspreadsheets.com/excel-vba-copy-paste/
 
Found a great article about Cartesian Product (Cross join), using Power Query. I usually use one of following methods in PowerQuery.
- Create Custom Column with value of 1 on all tables and joined based on that column
- For simple 2 table (2 columns) Cartesian Product, wrote SQL statement.

However, I found method in the link to be very simple and quick to implement, even if you had very little knowledge of databases. Especially useful if you need to create list of all possible combination of options for a product etc.

http://www.excelguru.ca/blog/2016/05/11/cartesian-product-joins-for-the-excel-person/
 
Back
Top