| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locate data macro
I have a list using unique coded ref numbers.
During the data entry process, if the unique code has already been entered, I use this statement "=1=COUNTIF($A$5:$A$238,A7)" to warn the operator that it has already been entered and to display the cell ref where it is located. I would like to create a macro that will locate the record once the warning is activated. Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locate data from a chart by inserting data into a cell | Excel Worksheet Functions | |||
| HELP I need to locate invalid data and I don't know how! | Excel Discussion (Misc queries) | |||
| How to locate duplicate data | Excel Discussion (Misc queries) | |||
| LOCATE DATA IN ONE SHEET AND APPLY ATTACHED DATA TO ANOTHER | Excel Discussion (Misc queries) | |||
| how can i locate duplicate data in an excel data table? | Excel Worksheet Functions | |||
![Malcolm McM[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
