| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation
Dear,
I need an option where in a cell if some text data is entered, it should validate the value entered from a range of cells within the same sheet/from a different sheet of an excel and should correct the name (if wrong) or retain the same (if correct). Hope my query is clear. In detail.. I have a list of company names around 200 and when i extract data which has company names, and paste it in a range of cells it should validate the company names from the source and corect or retain. Please help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation
You can identify the values which are not in the list but to correct it there
should be some logic to identify the correct name... "Sasikiran" wrote: Dear, I need an option where in a cell if some text data is entered, it should validate the value entered from a range of cells within the same sheet/from a different sheet of an excel and should correct the name (if wrong) or retain the same (if correct). Hope my query is clear. In detail.. I have a list of company names around 200 and when i extract data which has company names, and paste it in a range of cells it should validate the company names from the source and corect or retain. Please help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation
Dear,
Is it possible to identify few text strings, check whether it is matching with the source list and rectify the correct one if it is wrong. Also suggest me other options if this is not possible. Thanks in advance. "Sheeloo" wrote: You can identify the values which are not in the list but to correct it there should be some logic to identify the correct name... "Sasikiran" wrote: Dear, I need an option where in a cell if some text data is entered, it should validate the value entered from a range of cells within the same sheet/from a different sheet of an excel and should correct the name (if wrong) or retain the same (if correct). Hope my query is clear. In detail.. I have a list of company names around 200 and when i extract data which has company names, and paste it in a range of cells it should validate the company names from the source and corect or retain. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Data Validation Update Validation Selection | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Linear Mode
