-
Newest Blog Post
-
Recent Posts
- Tom’s Tutorials For Excel: Copying Multiple ListBox Selections to Worksheet
- Tom’s Tutorials For Excel: Summing to Today’s Date With INDIRECT
- Tom’s Tutorials For Excel: SUMIF For Days Past Last Date
- Tom’s Tutorials For Excel: Horizontal SUMPRODUCT
- Tom’s Tutorials For Excel: Formatting Numbers and Text With Custom Colors
Recent Comments
- Tom Urtis on Tom’s Tutorials For Excel: The INDIRECT Function
- Biray Kocak on Tom’s Tutorials For Excel: The INDIRECT Function
- Tom Urtis on Tom’s Tutorials For Excel: Reading the Registry for Your Email Client
- Jon Peltier on Tom’s Tutorials For Excel: Reading the Registry for Your Email Client
- Tom Urtis on Tom’s Tutorials For Excel: Updating Links (or Not)
Archives
Akismet Spam Counter
Total Spam Fought: 9,958
Monthly Archives: October 2011
Tom’s Tutorials For Excel: Save Each Worksheet As Its Own Workbook
Tom’s Tutorials For Excel: Save Each Worksheet As Its Own Workbook For the active workbook, this macro saves each visible worksheet as its own workbook in the current path. Workbooks are named as their sheet tab name, example, Sheet1′s workbook … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Calculating Salary Overtime
Tom’s Tutorials For Excel: Calculating Salary Overtime The picture shows how you can set up a worksheet to calculate weekly salaries for your employees, considering hourly wages and overtime hours. The formula in cell D5 that was copied down to … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Calculating Salary Overtime, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Capturing Cancel With InputBoxes
Tom’s Tutorials For Excel: Capturing Cancel With InputBoxes In VBA, there are two kinds of InputBoxes: The InputBox Function and the InputBox Method. Visually, they appear similar and in fact serve most of the same purposes, with the InputBox Method … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Capturing Cancel With InputBoxes, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: The INT Function
Tom’s Tutorials For Excel: The INT Function The INT function rounds a number down to the nearest integer. Example, in cell A1 is 2.7. In cell B1, the formula =INT(A1) returns 2. For negative numbers, INT returns the next number … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, The INT Function, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Reverse Intersect Lookup for Headers
Tom’s Tutorials For Excel: Reverse Intersect Lookup for Headers I recently posted this example, followed by this more advanced example for finding an intersecting value in a table with multiple rows and columns. Today it’s the opposite scenario, where you … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Reverse Intersect Lookup for Headers, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: The INDIRECT Function
Tom’s Tutorials For Excel: The INDIRECT Function The INDIRECT function returns a range reference based on a text string, which can return a value associated with that range reference. INDIRECT is a very versatile function, best explained by examples as … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, The INDIRECT Function, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
2 Comments
Tom’s Tutorials For Excel: Move Embedded Charts to Their Own Chart Sheet
Tom’s Tutorials For Excel: Move Embedded Charts to Their Own Chart Sheet Here is a macro that will move all embedded charts on a worksheet to their own Chart sheet. The Select method for cell A1 (it could be any … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Export Word To Excel
Tom’s Tutorials For Excel: Export Word To Excel For importing part of a Word document into your Excel workbook, here is a macro that imports the second paragraph from a Word doc. Sub ExportWordToExcel() ‘Declare object variables. Dim WdApp As … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: the NETWORKDAYS Function
Tom’s Tutorials For Excel: The NETWORKDAYS Function In many business situations, days must be counted as “business days” rather than as “calendar days” to represent the actual non-weekend, non-holiday days that have passed between two dates. For this purpose, the … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, NETWORKDAYS Function, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Summing Cells Across Worksheets
Tom’s Tutorials For Excel: Summing Cells Across Worksheets Here are formulas that sum numbers in a single cell, and in a range of cells, across multiple worksheets. The first picture shows a section from four different worksheets, each displaying Income … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Summing Cells Across Worksheets, Tom Urtis, Tom's Tutorials for Excel
Leave a comment
