goodwin57
07-17-2008, 05:31 AM
I'd like a worksheet_selectionChange(By Val Target as Range) macro to:
On a change in the range D4:Q300
Delete all values in columns B and C
Set column b values with reference to formula:
For each cell going down column B.
if the lookup of: b (offset-1 [i.e. a]) is in the range D:D, f:f,h:h,j:j,L:l,N:n,P:P then print an x in column b for each occurence of A in that range.
if c offset by -2 (i.e. a) is in the range as above except offset by 1 then do the same.
Any suggestions would be much appreciated
On a change in the range D4:Q300
Delete all values in columns B and C
Set column b values with reference to formula:
For each cell going down column B.
if the lookup of: b (offset-1 [i.e. a]) is in the range D:D, f:f,h:h,j:j,L:l,N:n,P:P then print an x in column b for each occurence of A in that range.
if c offset by -2 (i.e. a) is in the range as above except offset by 1 then do the same.
Any suggestions would be much appreciated