WISDOMBYDATA
  • BLOG
    • Blog Guide
    • Blog History
  • EXCEL
    • Functions & Formulas
    • VBA & Macros
    • VLOOKUP
    • Pivot Tables
    • Conditional Formatting
    • Tricks & Shortcuts
  • BI
    • SAP BOBJ/BW
    • Tableau
  • SQL
  • ABOUT
    • About WBD
    • About Me

 Combine data from multiple workbooks into a single workbook ​



​Combine data from multiple worksheets into master worksheet



Concatenate cells and remove unwanted commas between values in MS Excel (Using a Macro)



CREATE LAST UPDATED TIMESTAMP USING A MACRO



Temporarily highlight the entire row when any cell in that row is selected



​Speed up your Macros



How to transfer data (including blanks) from multiple excel sheets into a single repository



Ascertaining the folder path using a Macro



​Transfer Data from multiple Excel sheets into a single repository



Delete content of cells which cells have a specific background color



Highlight only part of the text in a cell in MS Excel



Copy a data set from one range into a different range in a different range in another tab using macros



How to Email only one (of many) tabs/worksheets directly through MS Excel



Sum cells in MS Excel based on background color



​Cracking Passwords on Protected MS Excel Tabs!



​Inserting Duplicate Rows Based on Numeric Values in a column


Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Picture

Powered by Create your own unique website with customizable templates.
  • BLOG
    • Blog Guide
    • Blog History
  • EXCEL
    • Functions & Formulas
    • VBA & Macros
    • VLOOKUP
    • Pivot Tables
    • Conditional Formatting
    • Tricks & Shortcuts
  • BI
    • SAP BOBJ/BW
    • Tableau
  • SQL
  • ABOUT
    • About WBD
    • About Me