In this post, I am going to discuss an option for creating a dynamic filepath for use as a Source in an Excel to Power Query connection.
Continue reading “Create a Dynamic Filepath for Power Query Connections”Tag: Excel
Locking & Unlocking Cells in a Range
In this post, I am going to show you how to lock and unlock cells using Conditional Formatting and VBA.
Continue reading “Locking & Unlocking Cells in a Range”Delete Table Rows using VBA
In this post, I am going to show you how to delete Excel table rows based on criteria using VBA.
Continue reading “Delete Table Rows using VBA”Mail-Merge Excel to Word
In this post, I am going to show you how to complete a mail-merge from an Excel table to Microsoft Word.
Continue reading “Mail-Merge Excel to Word”Minutes to Decimal Hours (tenths)
In this post, I am going to show you how to create a formula to convert time duration into tenths of an hour using Excel.
Continue reading “Minutes to Decimal Hours (tenths)”