Excel Forum
Similar Content
Select Data from Separate Worksheets with Macros VBA in Excel
Tutorial: Select data from other worksheets with Macros and VBA without navigating to those workshee...
Vlookup Across Multiple Workbooks
Tutorial: How to use the VLOOKUP function across multiple workbooks in Excel. This will create a lin...
Convert Month Name to Number and Vice Versa in Excel
Tutorial: How to convert a month's name, such as January, into a number using a formula in Excel; al...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell


Download file: http://people.highline.edu/mgirvin/
Given that that each sheet summarizes daily data and each sheet is names 1, 2, 3, 4 etc., See how to Create Sequential Dates Across Sheets using the REPLACE, CELL and SEARCH functions and Date Math. In this video learn how to:
1. Extract sheet name and put in cell using REPLACE, CELL and SEARCH functions
2. Date Math
3. Highlight consecutive Sheets using the Shift Key
4. Drilling Through to put one formula on many sheets with one action

Excel Magic Trick 756.5: Add Monday To Friday Sales Only From Totals On Many Sheets





Got a Question? Ask it Here in the Forum.