Mr Excel & excelisfun Trick 29: Existing Customers In Prospect List?
Loading...
Loading...
2,400
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (6)
-
I do not know how to do that, but it is possible with VBA. Since I am nor good with VBA, try posting question to:
mrexcel[dot]com/forum
There are 100s of VBA masters at that site.
-
use keuboard shortcut instead of TODAY fuunction:
Ctrl + ;
Ctrl + ; is the keyboard shortcut for today's date.
--excelisfun
P.S. Mr Excel is Bill Mr Excel Jelen.
Loading...
7:46
Mr Excel & excelisfun Trick 30: Count Bills for Money Transactionby ExcelIsFun2,334 views- 4:29
Mr Excel & excelisfun Trick 28: Find Earliest Date From List Of Dates Given 2 Criteriaby ExcelIsFun3,373 views
- 9:41
Mr Excel & excelisfun Trick 31: Word Wrap Problem: Formula or VBA solution?by ExcelIsFun3,644 views
- 3:57
Mr Excel & excelisfun Trick 21: Excel 2010 Sparklines (Amazing Cell Charts!!)by ExcelIsFun14,327 views
- 6:52
IT Skills: Excel - Display two different sets of data in the SAME chart with Secondary Axisby RikkisRefreshers10,060 views
- 5:25
Organize Your Billsby MsRevenda8,169 views
- 4:58
Different Drop Down Lists in Same Excel Cellby contextures28,020 views
- 9:41
Mr Excel & excelisfun Trick 75: Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX?by ExcelIsFun4,037 views
- 4:05
Mr Excel & excelisfun Trick 46: Lookup a value and Retrieve the two items to the Right INDEX & MATCHby ExcelIsFun1,671 views
- 8:16
Mr Excel excelisfun Trick 62: Conditional Format Chart Auto Feature or Formulaby ExcelIsFun5,978 views
- 10:05
Mr Excel & excelisfun Trick 73: Coax Time Value From Text: MOD, LEFT, RIGHT, TEXT, MOD Functionsby ExcelIsFun2,129 views
- 8:06
Mr Excel & excelisfun Trick 36: VLOOKUP w Approximate Match & Unsorted Tableby ExcelIsFun4,898 views
- 9:03
Mr Excel & excelisfun Trick 74: Dynamic Range For VLOOKUP & Data Validation List - Table Featureby ExcelIsFun3,718 views
- 8:47
Mr Excel & excelisfun Trick 38: Weekly Report Formula or Pivot Table?by ExcelIsFun9,262 views
- 5:24
Mr Excel & excelisfun Trick 58.5: Sorting Formula For Biggest Sales and Sales Rep Names with Tiesby ExcelIsFun2,838 views
- 4:32
Excel Magic Trick #395: When ROUND function Must Be Usedby ExcelIsFun1,898 views
- 5:13
Mr Excel & excelisfun Trick 61: Formula To Report Cell Reference 5 Examplesby ExcelIsFun1,796 views
- 4:08
Mr Excel & excelisfun Trick 64: Extract Records With Not Criteria VBA or Filterby ExcelIsFun3,659 views
- 6:29
Mr Excel & excelisfun Trick 67: Extract Initials From Full Name: VBA or Formula?by ExcelIsFun3,109 views
- 10:27
Mr Excel & excelisfun Trick 54: Approximate Lookup To Return Multiple Itemsby ExcelIsFun3,727 views
Hehe, Bill gets a small part at the end. Looks cool, I didn't know you could cascade two sheets next to each other.
Mynotoar 2 years ago
Yes, and the REAL power from showing two worksheets in two windows is that you don't get the sheet reference words when you click on a cell on the same sheet as the formula is housed. This is HUGE if you have large formulas with many sheet references. I am actually going to do a video on just this topic, later...
ExcelIsFun 2 years ago