Replies

You could add workbook macros:

Code:

' examples checking for minimum size for column A


Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Columns("a:A").ColumnWidth < 12 Then Columns("a:A").ColumnWidth = 12 
MsgBox ("before save")
End Sub

Private Sub Workbook_Open()
If Columns("a:A").ColumnWidth < 12 Then Columns("a:A").ColumnWidth = 12 
MsgBox (" On Open ")
End Sub


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Columns("a:A").ColumnWidth < 12 Then Columns("a:A").ColumnWidth = 12 
End Sub

Brute force option: – do a separate lookup table on your summary page, then search that…

Code:

	A	    	B		C	D
1	Find me:    	=VLOOKUP(B1,Summary!B3:B14,2,FALSE)		
2				
3	January		=VLOOKUP(B1,January!A3:F131,2,FALSE)		
4	February	=VLOOKUP(B1,February!A3:F131,2,FALSE)		
5	March		=VLOOKUP(B1,March!A3:F131,2,FALSE)		
6	April		=VLOOKUP(B1,April!A3:F131,2,FALSE)		
7	May		=VLOOKUP(B1,May!A3:F131,2,FALSE)		
8	June		=VLOOKUP(B1,June!A3:F131,2,FALSE)		
9	July		=VLOOKUP(B1,July!A3:F131,2,FALSE)		
10	August		=VLOOKUP(B1,August!A3:F131,2,FALSE)		
11	September	=VLOOKUP(B1,September!A3:F131,2,FALSE)		
12	October		=VLOOKUP(B1,October!A3:F131,2,FALSE)		
13	November	=VLOOKUP(B1,November!A3:F131,2,FALSE)		
14	December	=VLOOKUP(B1,December!A3:F131,2,FALSE)