|
|
#2
05-04-2018, 02:32 AM
|
|||
|
|||
Before I can advice anything, I have a couple of questions.
1. Why doesn't user enter new ID's and updates to existing ID's directly into main sheet? I.e. how are data processed? 2. What happens when there are new ID's or existing ones for updating entered? Are entries on main sheet updated somehow? 3. When main sheet is updated, what happens with data (used to update) in other sheets afterwards? 4. What happens, when existing ID is entered as new one? Or when non-existing ID is entered for updating? 5. Can there be cases, where existing ID must be deleted? 
|
| Tags |
| conditional format, index, vlookup |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Generated spreadsheet in SLK format causes message upon browsing: format / extentsion don't match.
|
PhillJ | Excel | 4 | 08-22-2017 03:10 AM |
| Index/match, Vlookup? | kelwea | Excel | 1 | 01-24-2017 10:19 AM |
| Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
| Index match vba | grexcelman | Excel | 0 | 03-05-2015 10:55 PM |
| UDF multiple IFs INDEX-MATCH | grexcelman | Excel Programming | 0 | 02-22-2015 04:20 PM |
Windows 8 
Office 2016
Threaded Mode