Batch add Validation Input Messages?

[mmenashe]

I have about 200 rows, all the items on the first page need a validation input message....

I can make an identical set of 200 rows on the second sheet, with the info each of them need

Is there a way to add this kind of stuff automatically??

thanks

Matt

 

[GlennUK]

Can you explain what's on the second sheet exactly, and how you want that incorporated into the Data Validation function for the first sheet?

 

[mmenashe]

Hi Glenn, thanks for your interest

well, here is a simplified version

Excel Workbook
	A
1	dog
2	dog
3	cat
4	cat
5	dog
6	bird
Sheet1

Excel 2003

Excel Workbook
	A
1	rex
2	fido
3	thaddeus
4	schnookums
5	biter
6	polly
Sheet2

Excel 2003

and the real deal is a bit more complex

its the company name on the first sheet, and a range of company info on two rows (A:AB), the header row and the info row

As for validation input message, Im talking about when a cell is highlighted, Data>Validation>Input Message

thanks

Matt

PS, if there is an alternative way to do it with a pop up window or something similar, Im interested, it doesnt have to be this method

 

[GlennUK]

Can anyone else understand what Matt is asking for? I can't make head nor tail of it.