Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation to check Dynamic range in another sheet
Hi all,
I have a macro which copies data from an input sheet to data sheet for eg. I have A number in sheet1 A1 which will be copied to sheet2 A1,a2,a3 etc can i use a data validation in sheet1 A1 not to repeat the same number which is already in sheet2 column A ? ( for each input sheet column a will have one more record. so the number of rows is not fixed. something like a datavalidation formula : =indirect(countif("Sheet2!MyRange"))not morethan 1 ??? TIA Soniya |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation to check Dynamic range in another sheet
Data validation only applies to manual entry of data. While it is not clear
what you want, it doesn't sound like you want to apply it to manual entry of data. -- Regards, Tom Ogilvy Soniya wrote in message ... Hi all, I have a macro which copies data from an input sheet to data sheet for eg. I have A number in sheet1 A1 which will be copied to sheet2 A1,a2,a3 etc can i use a data validation in sheet1 A1 not to repeat the same number which is already in sheet2 column A ? ( for each input sheet column a will have one more record. so the number of rows is not fixed. something like a datavalidation formula : =indirect(countif("Sheet2!MyRange"))not morethan 1 ??? TIA Soniya |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation to check Dynamic range in another sheet
Yes Tom,
I want to apply it for manual entry of data.. only thing is that it should not accept a number which is already entered in that cell which is sroed in the next sheet in a specific column Soniya -----Original Message----- Data validation only applies to manual entry of data. While it is not clear what you want, it doesn't sound like you want to apply it to manual entry of data. -- Regards, Tom Ogilvy Soniya wrote in message ... Hi all, I have a macro which copies data from an input sheet to data sheet for eg. I have A number in sheet1 A1 which will be copied to sheet2 A1,a2,a3 etc can i use a data validation in sheet1 A1 not to repeat the same number which is already in sheet2 column A ? ( for each input sheet column a will have one more record. so the number of rows is not fixed. something like a datavalidation formula : =indirect(countif("Sheet2!MyRange"))not morethan 1 ??? TIA Soniya . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation List from a Dynamic Named Range on Another Workshe | Excel Worksheet Functions | |||
Dynamic name range for use in data validation | Excel Worksheet Functions | |||
Data Validation via Dependent List defined by Dynamic Range | Excel Discussion (Misc queries) | |||
dynamic range and data validation | Excel Worksheet Functions | |||
Dynamic Range, Data Validation and Address, Match and Offset Funct | Excel Worksheet Functions |