check group status

macropod · #1 05-01-2012, 12:23 AM

Hi userman,

You could do the check with a macro, or possibly even with a formula, though having a variable number of columns per record makes this more difficult. However, it is not clear what you want to do with the results - suppose one record is found to be 'NOT OK', what then?

userman · #2 05-01-2012, 05:33 AM

Quote:

Originally Posted by macropod

Hi userman,

You could do the check with a macro, or possibly even with a formula, though having a variable number of columns per record makes this more difficult. However, it is not clear what you want to do with the results - suppose one record is found to be 'NOT OK', what then?

if one record is 'NOT OK', then the whole group that this record (row) belongs is 'NOT OK'

then, let's have a report, a list of all the groups and their status at a right column

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Resource Status	BrownHornet	Outlook	0	04-12-2012 10:47 PM
Link word check box to access check box	Mrkieth	Word	4	01-30-2012 06:43 AM
Checking ref # status based on sheet2 ref #.	aligahk06	Excel	1	04-26-2010 11:22 PM
Sending 1 message but status bar says 1 of 4...	baldmancan	Outlook	4	03-06-2009 12:04 PM
Document status changes to read only	rtankersley	Word	0	10-01-2008 05:15 AM