Check for repeated input
 

Hi,

This is a bit of a long post for my first but here goes...

I have created a spreadsheet for which I want to check when enterin
data into a column whether this data has been repeated elsewhere in th
worksheet and on other worksheets. If it is repeated then a warnin
should be shown with options to continue or cancel. I can do thi
easily for a single worksheet using data validation but cannot think o
how this can be done between workbooks especially when the number o
workbooks can vary.

If I can manage to sort that then I'd like to offer an option to cop
the data from the row where the original reference was placed. As
further feature I would then like to be able to update all rows for
particular reference.

eg *01* Data X Data Y Data Z
*02* Data X Data Y Data Z
*03* Data X Data Y Data Z
*02* As 02 is entered option to paste data from line 02 above an
then track data between these lines to ensure that it's always th
same.

I know there's a lot to do there but any advice on any of the abov
would be hugely appreciated.

Many thanks in advance

--
Jamuc
-----------------------------------------------------------------------
Jamuck's Profile: http://www.excelforum.com/member.php...fo&userid=3054
View this thread: http://www.excelforum.com/showthread.php?threadid=50196

Check for repeated input
 

Any ideas anyone?:confused:


--
Jamuck
------------------------------------------------------------------------
Jamuck's Profile: http://www.excelforum.com/member.php...o&userid=30545
View this thread: http://www.excelforum.com/showthread...hreadid=501961

Check for repeated input
 

I guess that's a no then. Any help at all would very much appreciate
as it's driving me mad; I just can't figure out how to do any of this!
Please help!

--
Jamuc
-----------------------------------------------------------------------
Jamuck's Profile: http://www.excelforum.com/member.php...fo&userid=3054
View this thread: http://www.excelforum.com/showthread.php?threadid=50196