Excel Posts by Dr Dinesh kumar Takyar

2021 (57)

September 22 : Open Specific Worksheet at Specific Location on Opening Workbook
September 10 : Print Specific Multiple Sheets Automatically
September 1 : Get Data from Outlook Address Book Automatically
August 27 : Open UserForm in Another Workbook
August 21 : 2021 | Recover Data From Protected Excel File| Google Sheets
August 17 : Using Application.Run in Excel VBA
August 10 : Print Header on First Page
July 28 : Writing Macros in Google Sheets
July 21 : Fix Position of Form Control Button on Worksheet
July 14 : Display Duplicates or Unique Values Using Power Query
July 8 : Validate Time Entry in TextBox on UserForm
June 30 : Automatically Extract Table Data from Outlook Mail
June 23 : Filter Data Based on Criteria in Selected Cell
June 16 : Get Data from Contacts Folder in Outlook Automatically
June 10 : Dump Web Page Data into Worksheet
June 3 : Adding Month Sheets to Workbook Automatically
May 27 : Unzip Zip File
May 26 : Open File with Partial Name
May 23 : Select Random Data Automatically
May 22 : 3 Ways to Generate Large Amounts of Data
May 20 : Automatically Change Print Orientation
May 12 : Custom Function to Check Time Entries
May 4 : Worksheet Change Event to Enter Numerical Values
May 1 : Calling Function from Sub
April 27 : User Defined Functions UDF
April 24 : Macro Security Settings
April 22 : Delete Files And Folders Automatically
April 20 : Speed Up Macros
April 6 : Copy Charts from Excel to PowerPoint Automatically
March 30 : Super Quick Method to UNSTACK One Column of Data into Multiple Columns
March 24 : Copy Every Nth Row of Data From Sheet1 to Sheet2
March 18 : Remove Blank Rows
March 13 : Using TRIM Function in VBA
March 6 : Index Match and Xlookup
February 28 : Custom Data Types in Excel 365
February 17 : Turn Off Autocomplete in Specific Columns in Excel
February 12 : UNIQUE function
February 4 : STOCKHISTORY FUNCTION
January 29 : Using Sort With Filter
January 28 : Filter Function in Microsoft Excel 365
January 27 : Clean Data Using Flash Fill in Excel
January 26 : Using Lambda for Iterations or Recursion
January 25 : Lambda Functions in Microsoft Excel
January 24 : Google Sheets for Translation
January 23 : Translation in Excel Without VBA
January 22 : Perform Calculations on Data in Text Boxes Without Command Button
January 21 : Track Changes in Excel Worksheet Without VBA
January 20 : Analyze Large Amounts of Data in Excel
January 19 : Copy Paste PDF Data into Excel
January 18 : PDF to Excel Using Power Query
January 17 : Print Latest Data
January 16 : Sending Reminder from Excel Using Gmail with CDO
January 15 : Forward Message via whatsapp Desktop
January 14 : Whatsapp Desktop Automation with VBA
January 13 : Upload Image PDF and Video files automatically via Whatsapp
January 12 : Unstack Multiple Columns of Data
January 11 : Automatically Send Message with Image via Whatsapp

2020 (50)

October 26 : Create Folders and Files Automatically
October 21 : Automatically Highlight Column Header
October 2 : Import Data from Multiple Worksheets in Multiple Workbooks Using Power Query
September 28 : Combine Worksheets Data Using Power Query
September 4 : Power BI Desktop Data Analysis Visualizations
August 24 : Copying Rows between Workbooks Based on Text Value
August 16 : Xlookup function
August 7 : List Files in Folder Create Hyperlink
July 31 : Hide Show Ribbon in Excel Using VBA
July 24 : Extract Data from Word Document Using Word and Excel VBA
July 21 : Create Data Entry Forms under 10 seconds No VBA
July 16 : Create Forms with Microsoft Forms App
July 1 : Add Comments to Data from Another Worksheet Column
June 30 : Get Outlook Data from Chosen Folder
June 23 : Sort Worksheet Tabs By Color
June 21 : Convert PDF to Excel Using VBA
June 18 : Copy Paste Filtered Data to Another Workbook
June 16 : DateAdd Function in VBA
June 7 : Run Macro when Result of Formula Changes
June 2 : Open Any Third Party Application Using Shell Function
May 28 : Convert Multiple Sheets To Multiple PDF Files
May 16 : Automate Extraction of Specific Word from Outlook Message
May 10 : Filter Data into List box using two Combo boxes data as Criteria
May 4 : Automating Analysis of CSV Files with ADO SQL
April 29 : Automating Rank Worksheet Function
April 23 : Remove Duplicates Automatically Based on Entries in Multiple Columns
April 21 : Get Data from Multiple CSV or Text Files into Excel Worksheet
April 20 : Simple Inventory System without VBA
April 18 : Find And Replace Multiple Words in Word Document
April 17 : Using Activex Controls SQL VBA to Analyze Excel Data
April 16 : Using ADO and SQL with VBA
April 16 : Highlight Differences in Two Lists
April 15 : Automatically Pop-Up Find Dialog Box
April 15 : Free Add In Called Range Calculations
April 13 : Free Date and Time Picker Add In
April 13 : Automatically Find First and Last Working Day in Month
February 18 : Allow Data Entry into Excel Worksheet Via User Form Only
February 10 : Automate Saving New File Version
February 7 : Create Searchbox Using Filter Function Automatically
January 30 : Create Multiple Copies of Master Sheet Automatically
January 28 : Create UserForm with Web Browser Functionality
January 28 : A Super Simple Inventory Automation System
January 28 : Automatically Create Message Box with Timer
January 28 : Import Email Attachments from Outlook into Excel Automatically
January 28 : Filter Data for Current Month or Year
January 28 : Send Emails From Specific Account in Outlook
January 27 : Send Emails to Multiple Persons with Multiple Attachments
January 27 : Create Plus Minus Switch
January 27 : Automate Language Translations Using Excel VBA
January 27 : Print Only Hidden Worksheets Automatically

2019 (54)

December 13 : Convert Charts in Excel Worksheets Automatically to Images
November 12 : Convert Each Worksheet in Workbook to Text File
November 8 : Copy User Form Image to Worksheet Automatically
October 31 : Copy Data Using Advanced Filter with VBA
October 21 : What is Dictionary in Excel VBA
September 26 : Copy Multiple Columns Data from Worksheet to Worksheet
September 23 : Get stock data from Exchange at specific intervals automatically
September 20 : Automatically Protect Workbook with Password
September 13 : Move from one control to another in a form on worksheet
September 8 : Automatically Clear Contents of Worksheet without Clearing Formulas
September 3 : Make Super Fast Data Entries Automatically
August 26 : Userform to Manage Data Automatically
August 21 : Copy Non Adjacent Cells Data from Multiple Workbooks
August 19 : Highlight Differences in 2 Lists Automatically
August 16 : Display Worksheet Data Quickly and Easily
August 13 : Copy Today’s Worksheet
August 8 : Super Easy Secure Data Entry Form
August 5 : Create Data Entry Form on Worksheet
August 2 : TREND Function in Excel
July 27 : Automate Formatting of Data with Symbols
July 25 : Unstack Data Automatically
July 22 : Create Report from Duplicate Data in Worksheet
July 20 : Calculate Change Percentage Automatically as you Type
July 17 : Calculate Total Automatically as You Type using VBA
July 15 : Create Dynamic User Form with two Dependent Combo Boxes
July 14 : Calendar Control for All Office versions
July 14 : Animations for User Interfaces
July 14 : Update Master Sheet with a Click
June 28 : Create Report Quickly with VBA
June 26 : Sort Data in Worksheet As We Type Automatically
June 17 : Prevent Change of Worksheet Tab Names
June 16 : Navigating Worksheets Using Combobox Activex Control
June 11 : Find Specific Word in Text
June 7 : Create Interactive Checklist
May 29 : Validate Alphanumeric Data
May 27 : Use UP and DOWN Keys
May 20 : Efficiency of Arrays in Calculations
May 8 : Two Methods to Loop through Worksheets
May 3 : Automatically Prevent Printing of Shapes
May 1 : Automate Date Validation Using VBA
April 22 : Return of Multiple Match Results Automatically
April 2 : Analyze Data Using DGET Function
March 30 : Display All Files in Folder in Worksheet
March 27 : Display List of All Files in Folder in Combo Box
March 18 : Create Multiple Slicers Using Table Data Automatically
March 17 : Automate Slicer Creation Using Table Data
March 7 : Display Data in Listbox based on Combo Box selection
March 2 : Prevent Worksheet Name Change
February 26 : Extract Specific Data from MS Word into Excel with VBA
February 15 : How to Display Data on User Form Controls
February 14 : How to Open Most Recent File from Specific Folder
January 31 : How to List Recent Files with VBA
January 21 : Insert Picture in Multiple Worksheets Automatically
January 16 : Sort Worksheets Tabs Automatically with VBA

2018 (58)

December 26 : Allow Editing in Protected Worksheet with VBA
December 12 : Launch VB Script Using Task Scheduler
December 3 : Run Macro Automatically without Opening Excel File
November 13 : Automate Backup of Current File Quickly
November 4 : Automate Loan Amortization Schedule
October 29 : Create Reports with Loops
October 22 : Hide Formula in Worksheet Without Protecting Worksheet
October 14 : Consolidate Data Using VBA
October 7 : Create Product Catalog Automatically
September 28 : Quick and Easy Inventory
September 22 : Variable Scope
September 18 : Navigate Database Automatically
September 13 : Delete Data from Database Automatically
September 6 : Update Record in Database Automatically
August 27 : Place an Image in Database Worksheet
August 24 : Create Database in Excel Quickly and Easily
August 23 : Worksheet Change Event to Run a Macro
August 22 : Activate R1C1 Reference Style Automatically
August 14 : Count Number of Print Pages on Worksheet with VBA
August 10 : Add Header Footer to Worksheet
July 21 : Automate Format Painter
July 19 : Format Data for User Friendly Presentation
July 11 : Nested Loops and How to Run Macros
July 9 : Create Table of Contents
July 5 : Prevent Data Copying
July 4 : How to Open Another App from Excel
June 29 : Scrape Web Data with Google Chrome
June 26 : Highlight Misspelling and Correct Automatically
June 25 : Automating Membership Payments with User Form
June 19 : Avoid Duplicate Customer Details in Invoice Tracker
June 18 : Autofit Data Automatically
June 10 : Invoice Tracker
June 9 : Fill Web Form with User Form Data
June 2 : Get Worksheet Name into Worksheet Range
May 28 : How to send pesonalized emails automatically
May 21 : Copy Sheet1 Data from Multiple Workbooks
May 14 : Zip Files Using VBA
May 1 : Update Data in worksheet on Workbook Open
April 29 : Send Numbered Message Automatically through Outlook
April 21 : Search Multiple Values in Worksheet Data
April 11 : How to Update Mastersheet
April 3 : How to Log into Gmail Automatically
March 26 : How to Copy Data from Unknown Range with VBA
March 21 : Using Caller Property of Form Controls
March 14 : Get Data from Outlook into Excel based on multiple criteria
March 12 : Get Data from Outlook into Excel worksheet
February 24 : How to send Email through Outlook at Specific Tme
February 21 : How to use DSUM Function in VBA code
February 19 : Calculate Average with Do While Loop
February 7 : Automatically Display Worksheets of Specific User
February 3 : Validate Date Entry in Inputbox
January 31 : Generate Report Based on Dates
January 22 : Get Data from UserForm into Table
January 18 : Inventory Management Using Tables in Single Excel Sheet
January 15 : Inventory Management Using Tables in Excel
January 13 : How to perform Vlookup from Closed Workbook
January 9 : Compound Interest Calculation Using Custom Function
January 4 : Create Function and Call it

2017 (61)

December 29 : Data Entry With UserForm Vlookup Countif Dynamic Named Ranges
December 27 : Fill ListView Control with Data from Worksheet
December 20 : Convert Excel File to Password Protected PDF File with VBA
December 11 : Using Vlookup with Indirect Function in VBA
December 8 : How to Open Folder in Excel Using VBA
December 4 : How to Copy Column Data into Another Workbook
December 4 : How to create progress bar in Excel with vba
November 28 : How to Display Multiple Charts from Excel Worksheet on UserForm
November 24 : Inventory Management with UserForms
November 17 : How to Add Data in Non Contiguous Cells with VBA
November 17 : How to Place Relevant Image on User Form based on Data filled in Text Boxes
November 15 : Fill Text Boxes on User Form Based on Selection in Combobox
November 13 : How to Merge Data from Two Excel Worksheets
November 11 : How to Archive Invoices Data Using VBA
November 5 : How to Find Last Row Used in Excel Worksheet with Blank Columns
November 4 : How to Add List Box Controls on UserForm at Runtime
November 2 : How to Create Labels at Runtime
October 27 : How to Create Text Boxes on User Form at Runtime
October 14 : How to Print Non Blank Pay Slips
October 12 : Automate Deleting Duplicate Dates Insert Rows Make Date Entries
October 7 : Convert Date Formats
October 4 : Automatically Update Inventory while Creating Invoice
September 27 : Automate Invoice Creation with VBA
September 18 : Analyze Data with VBA and Create Specific Report
September 15 : Delete Data from Excel Worksheet Database via User Form
September 14 : Add Data to Any Sheet with User Form
September 10 : Search for Data In Excel Database with UserForm
September 10 : Update Records in Excel Database with User Form
September 6 : Add Data to Excel Database with UserForm using Countif Function
September 3 : How to Code Clear and Add Command Buttons on userform
September 1 : Create UserForms with Navigation Buttons
August 27 : Find and Extract All Specific Values from Excel data
August 27 : Copy Specific Files from Folder and Subfolders into Destination Folder
August 20 : Copy Specific Files or All Files from Source Folder to Destination Folder with VBA
August 7 : Get Meta Data from Webpage
July 31 : Excel VBA ComboBox Match Required
July 26 : Get Column Data from Closed Workbook
July 23 : How to get Excel data from multiple rows into a single cell
July 10 : How to Loop through SubFolders
July 2 : How to edit multiple excel files in a folder automatically
June 26 : Automating New Report Creation from Updated Raw Data
June 16 : Copy Table Data to New Worksheet with VBA
June 12 : Using Excel Indirect Function in VBA
May 31 : Using Index with Match in VBA for Lookups
May 25 : Transfer Specific Data to Specific Sheets Automatically
May 25 : Transfer Specific Data from Sheet1 to Sheet2
May 23 : Transfer Data from Sheet1 to Sheet2
May 17 : Vlookup from multiple tables
May 6 : How to use VLookup to get multiple values
May 3 : Create Data Bar Using VBA
April 20 : Find Last Row Column in Data with Blanks using VBA
April 10 : Filter Data in Combo Box
April 10 : How to add numerical values via text boxes in userform
March 17 : Compare 2 worksheets to create report
February 25 : Calculations with user form
February 17 : Create Summary Sheet Sort Data VBA
February 13 : Copy Paste Using Timer for Graph Visualizations
January 22 : Highlight Characters in String with VBA
January 16 : Format Function with Dates VBA
January 9 : How to use datediff function with user form
January 1 : Copy paste data repeatedly from sheet1 to sheet2

2016 (35)

December 25 : Automate Calculations with Time using VBA
December 10 : Get src attribute from img tag in web page with vba
November 17 : Extract Data from Multiple Tables in Web Page with VBA
November 6 : Create Reports from Raw Data with Loops Auto Filter VBA
November 5 : How to implement Advanced Filter Using VBA Code to Remove Duplicates
October 3 : Track Changes Automatically in Worksheet with VBA
September 17 : How to code command button of user form to create database
August 19 : Get Data from Random Check Boxes into Excel Worksheet
July 22 : Methods to transfer data from Excel worksheet with VBA
July 13 : Find last row column cell in an Excel worksheet with VBA
July 7 : Create Summary Sheet from Multiple Workbooks with VBA
July 1 : How to copy column data from closed workbook with VBA
June 23 : Merge Data from Worksheets into Master Worksheet
June 13 : How to highlight data in Excel using worksheet change event
June 8 : Inventory solution using worksheet selection change event
June 4 : How to avoid duplicate entries in Excel using Countif in VBA
May 29 : Calculate Time Difference between two times in hours minutes seconds with VBA
May 23 : Using DatedDif Function in Excel VBA
May 17 : How to check login password open specific worksheet
May 12 : How to display hidden worksheet based on password
May 3 : How to perform tasks in Excel at specific time
May 2 : How to make Excel workbook expire
April 16 : Calculations Conditional Formatting Counting with VBA
April 4 : Copy Paste Data in Excel with VBA
March 31 : How to transfer data from one sheet to another using wild card characters
March 23 : How to get data from worksheet into combobox and textboxes on user form
March 12 : Copy non blank data from sheet1 to sheet2 with VBA
March 5 : Copy auto filtered data to another worksheet automatically with VBA
February 18 : How to print hidden and visible worksheets with VBA
February 14 : Highlight Minimum values in rows in Excel Worksheet with VBA
January 28 : Create dependent combo boxes in Excel user form with VBA
January 21 : Search Data with VBA
January 15 : Using Find and FindNext Functions in VBA
January 13 : How to make Excel Worksheet Cells Flash with VBA
January 1 : Identify colored cells Excel worksheet and perform actions

2015 (51)

December 24 : Extract Data from Sheet1 to Sheet2 based on Date Criteria
December 17 : Create Manage Database in Excel with User Form
December 10 : How to Scrape Web Data Using Class Names with VBA
December 4 : Scraping Web Page Data of Drop Down List Options with VBA
November 26 : How to use SUMIF in VBA
November 21 : Check If Folder Exists with VBA
November 16 : How to create test in Excel with VBA
November 8 : Automate Calculation of Net Working Days with VBA
November 5 : Display Files in Folder with VBA
October 31 : Highlight Non Adjacent Cells and Total Their Values
October 29 : How to Run Macro from Another Workbook
October 23 : Add Data from User Form at Top Row below Headers with Excel VBA
October 20 : Format Dates in Excel with VBA
October 5 : Transfer Data from Invoice to Worksheet with VBA
September 27 : Get Data from Multiple Sheets in Multiple Workbooks into Master Workbook with VBA
September 23 : How to follow multiple hyperlinks and extract webpage data
September 14 : How to transfer data to an invoice template
September 9 : Update navigate records Excel worksheet with user form
August 28 : Using Timer to Automate Getting Data from Closed Workbook
August 19 : How to get multiple values from closed workbook using VBA
August 11 : Get Value from Closed Workbook with VBA
August 7 : Get Data from Access Database using Excel VBA
August 3 : Place Picture Excel Worksheet Range into User Form with VBA
July 22 : Date Time Picker Tool on User Form
July 20 : How to control the size of UserForm in Excel
July 20 : Copy Column Data into Different Columns in Another Excel Worksheet
July 7 : Color Highlight Data Using Excel VBA
July 3 : Why it is important to define variables with Dim in Excel VBA
June 28 : Count Change Shape Display Hide Comments using Excel VBA
June 4 : Copy Data from One Excel Sheet to Another using Time Criteria
May 27 : Enter numerical data in text boxes in userform using class module
May 21 : Transfer Data to Specific Excel Worksheet Using VBA
May 11 : Create splash screen using Excel VBA
May 5 : Create Excel Data Form Quickly with VBA
April 30 : Delete Blank Rows from Excel Worksheet Using Reverse For Next Loop
April 22 : Automate Search Display Print Archive Data with Excel VBA
April 16 : Automatically cut paste data rows from an Excel worksheet into another
April 10 : Automate Copy Paste Data in Non Adjacent Cells in Sheet1 to Sheet2 with VBA
April 8 : Automatically Password Protect Excel Worksheet and Lock Cells after Data Entry using VBA
April 2 : Looping Process to Automatically Check whether all Textboxes ComboBoxes ListBoxes are Completed before Sending Data to Excel Worksheet
March 27 : Ensure All Data Fields in UserForm Filled Before Transfer to Excel Worksheet Using VBA
March 17 : Automatically Open Specific Page in PDF Document Using Excel VBA
March 4 : Counting and Displaying Totals Automatically Using Excel VBA
February 23 : Get Data from MS Word Forms Automatically into Excel
February 19 : Create report with headers at specific positions using Excel VBA
February 15 : Automate Copying Excel Column Data from Sheet1 to Sheet2 with VBA
February 9 : Automate Mail Merge Using Excel VBA
February 4 : How to Follow Link on Web Page Automatically with VBA
February 4 : Vlookup Excel VBA
January 20 : How to Automate Display of Pictures Using Comments with VBA
January 8 : Automate Email Extraction from Website Using Excel VBA

2014 (38)

December 23 : Automate Scraping of Hyperlinks from Web Pages Using Excel VBA
December 12 : Automate Invoice Report Generation Using Excel VBA
December 5 : Copy Column Data Automatically from Excel Sheet1 to Excel Sheet2 with VBA
December 5 : Open PDF File Using Excel VBA
November 22 : Automate Excel to PDF and Email PDF Document using VBA
November 16 : Automatically Add Header Footer to Excel Document with VBA
November 8 : Automatically Track Changes in Excel Worksheet Without Sharing Workbook
October 31 : Automate Dates Calculations with Excel VBA
October 18 : Automaticcally Hide Workbook View User Form
October 9 : Automatically Search Excel Data Display Print Using VBA
October 2 : Using Dates with Excel VBA to Automate Email Reminders
September 26 : How to capture user input via input box and validate the data input automatically using Excel VBA
September 17 : Automating dash boards using list box form control with choose function
September 10 : How to transfer multiple rows of data from multiple workbooks into master workbook with VBA
September 4 : How to Automate Transfer of Excel data to Notepad
August 28 : Send Email Using Gmail with Excel VBA
August 21 : How to Scrape Title and Header H1 from Web Pages Using Excel VBA
August 12 : How to Avoid Duplicate Entries in Excel Worksheet While Transferring Data Via UserForm
July 31 : Database and Customer Relationship Management in Excel Using VBA Video 4
July 31 : Database and Customer Relationship Management with Excel VBA Video 3
July 31 : Database and Customer Relationship Management with Excel VBA Video 2
July 31 : Database and Customer Relationship Management with Excel VBA Video 1
July 23 : How to Display Pictures on Excel Worksheet Using VBA
July 17 : How to create report from Excel data sheet with VBA
July 9 : How to Generate Reports in Excel Using VBA
July 3 : Automatically send email to users queries in Excel with VBA
June 24 : How to Import Data from Word Tables into Excel with VBA
June 19 : Import Data into Word from Excel Using VBA
June 11 : How to Update Excel Worksheet Records with UserForm
June 4 : Archive Excel Data Using VBA
May 30 : Transfer Data from User Form to Multiple Worksheets in Excel Workbook Using VBA
May 28 : Transfer Specific Excel Worksheet Data Range from one Worksheet to another
May 21 : Create Invoices Using Template with UserForm in Excel
May 15 : Using Invoice Template to Automate Invoice Creation and Printing with VBA
May 9 : Timer in Excel Using VBA
April 28 : How to send email reminder automatically from Excel Worksheet using VBA
April 24 : Embed Excel Sheets in Web Pages
April 17 : How to Use MultiPage Control on UserForm in Excel