I basically need to delete :rambo: all rows (the whole row), that contain the value false in columns "D:H". It needs to have a false in ALL columns, not just 1. Thank you very much for all your help. :thanx: :kitty:
Posts by Foxxy1


Thanks, but...
I'm trying to get it to work and I kind'a get what's happening, but I'm trying to get a formula to copy downward and I'm just not grasping the concept. This is the formula I'm working with:
Please Help. Thanks again 
Is there a way to fill column "B" down to the very last cell located in column "A" when column a varies each time? Thanks for any help.

What I'm trying to get to work is for a macro to go through several columns (A,B,E,F, & G) and find error values associated values in 1 colmumn, with values being "N11, N12, N13, N21, N22, etc." that will vary, sometimes going from N11 through N110 or N11 through N117 etc. These values can reach N1 through N30 or more, and the list is in no particular order. I then need to compile a list of all the values (i.e. N11) with a cell containing an error value in any of the colums (A,B,E,F, or G) on a seperate sheet. If more info is need I would be happy to oblige. Thank you.
31RSS24MCWFRStartN111010#N/A#N/A
15RSS24MCWFWN11N1215250.041#N/A
ET70WP2475WFRN12N131439#N/A#N/A
15ET9024MCCFWN13N1430690.0450.145
AH24RN14N151001690.0500.100
CH9024WN15N16241930.0200.050
MBG624RN16N17622550.0300.030is my email address if more is needed (Edit: removed by Admin  see user profile)

Example
31RSS24MCWFRStartN111010#N/A#N/A
15RSS24MCWFWN11N1215250.041#N/A
ET70WP2475WFRN12N131439#N/A#N/A
15ET9024MCCFWN13N1430690.0450.145
AH24RN14N151001690.0500.100
CH9024WN15N16241930.0200.050
MBG624RN16N17622550.0300.030[email protected] is my email address if more is needed

What I'm trying to get to work is for a macro to go through several columns (A,B,E,F, & G) and find error values associated values in 1 colmumn, with values being "N11, N12, N13, N21, N22, etc." that will vary, sometimes going from N11 through N110 or N11 through N117 etc. These values can reach N1 through N30 or more, and the list is in no particular order. I then need to compile a list of all the values (i.e. N11) with a cell containing an error value in any of the colums (A,B,E,F, or G) on a seperate sheet. If more info is need I would be happy to oblige. Thank you.

Actually I was thinking about something else and if I can get that to work then it won't matter whether it's 1 or all. What I'm trying to get to work is for a macro to go through several columns and find error values associated values like "N11, N12, N13, N21, N22, etc." that will vary, sometimes going from N11 through N110 or N11 through N117 etc. These values can reach N1 through N30 or more, and the list is in no particular order. If more info is need I would be happy to oblige. Thank you again Tom.

I have a list of generally 17 rows (sometimes a little more) within my worksheet several times over. I'm curious if there is a way to setup a macro that will realize that if the value in the 1,2,5,6, and 7 columns are #N/A, that the row they are contained in need to be deleted. Thank you in advance for any help you can give.

I also have a zero value after the last cell with a value that I dont want to appear. If it is easier to start out with 3 columns with a list of values that will be of an unknown length and carry the same value multiple times and create 1 list in a column with all the values entered one time only, it would actually be better for me. Thanks

I'm trying to compile 3 seperate lists in 3 seperate columns, into 1 column. The length's of the list's will always vary and I cannot, therefore, make a macro to copy and paste into the same column because of this, at least to my knowledge. Is there a way to ignore the first cell in each column, also. If there is a way to do this, any help you can give I would appreaciate.

I'm trying to compile 3 seperate lists in 3 seperate columns, into 1 column. The length's of the list's will always vary and I cannot, therefore, make a macro to copy and paste into the same column because of this, at least to my knowledge. If there is a way to do this, any help you can give I would appreaciate. If you need more detail, please let me know. Thank you.