Table of Contents Example “Code” column is missing in table 1. “Country” and “Parts” are common columns in both the tables. Some of the countries and parts do not have code in Table 2 (India-Item1, UAE-Item2) Some of the countries and parts have code in Table 2 but do not have quantity in Table 1…
Table of Contents Task We have to combine month wise sales register spread across 12 files into one single file. 3 Steps Solution Step 1 – Keep all the files in one folder Step 2 – Go to Data Tab –> New Query –> From Folder –> Provide the folder path of the above –> Click Ok…
Table of Contents Download & Install Microsoft Power Query Check the Excel version – Is it 32 bit or 64 bit? Go to File Menu –> Account –> About Excel (visible in the End on first row) Click on the link to download Microsoft Power Query http://www.microsoft.com/en-us/download/details.aspx?id=39379 Click on the Download button Select the 32…
Table of Contents Steps to enable developer tab to insert code Enable Developer Mode from File -> Options -> Customize Ribbon -> Check Developer Click ok Press Alt + F11 Goto View Menu Click on Project Explorer to enable the panel on left. Go to Insert tab Click on Module You can now write your…
Table of Contents Steps to insert code Open the Visual Basic Editor using Alt + F11 Goto Insert Tab Click on Module Paste the below code into module Code Import Code into your file You can directly import the above code into your Excel file by following the below steps: Download the code file from…
Table of Contents In this article we will learn how to create list of all the sheets that exist in your excel workbook. You can click on the sheet name to go that sheet. Steps to insert code Open the Visual Basic Editor using Alt + F11 Goto Insert Tab Click on Module Paste the…
Table of Contents In this article we will learn how to unhide all sheets in excel using as simple VBA code Steps to insert code Open the Visual Basic Editor using Alt + F11 Goto Insert Tab Click on Module Paste the below code into module Code Import Code into your file You can directly…