|
Featured Tutorial
Featured Macro
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
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