|
|
|
|
#1
11-17-2015, 10:46 PM
|
|||
|
|||
Instead of Sheet1!$D$6 in the IF-part of the formula you can of course refer to another cell, for instance Sheet1!E1 and then enter the criteria (7 Habits S1 or something else) in this cell. After editing remember to hold down Ctrl and Shift before pressing Enter.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Help needed in excel VBA to transfer bookmarks
|
pat263 | Excel Programming | 7 | 11-11-2014 07:56 AM |
|
Urgent help needed for 2003 Macro to run in Excel 2007
|
fredang | Excel Programming | 1 | 12-27-2013 07:34 PM |
| Creating Lookup in Excel | vikash kumar | Excel | 2 | 12-06-2010 06:50 AM |
| Excel formula needed. | Rod | Excel | 1 | 08-03-2009 06:55 AM |
| Excel to lookup Access Database | PeterP | Excel | 1 | 06-11-2009 12:33 PM |
Windows 10 
Office 2013
Hybrid Mode