Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Info in F but AF and/or AY no info so delete the rows
I am looking for help getting a macro that works and performs the following
steps. Check Column F for information If Column F has information check Column AF and AY for information If Column AF and/or AY are empty delete the rows. Can you help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Info in F but AF and/or AY no info so delete the rows
I see you have changed the rules from your earlier posting in
worksheet.functions group. If Column F has information check Column AF and AY for information If Column AF and AY are empty delete the rows. Now it is "and/or" Which posting is correct? See reply to other posting. Gord Dibben MS Excel MVP On Thu, 4 Mar 2010 10:51:02 -0800, Louie wrote: I am looking for help getting a macro that works and performs the following steps. Check Column F for information If Column F has information check Column AF and AY for information If Column AF and/or AY are empty delete the rows. Can you help? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Info in F but AF and/or AY no info so delete the rows
Sorry Gord the "and/or" posting is correct, I made a mistake. My apologies.
"Gord Dibben" wrote: I see you have changed the rules from your earlier posting in worksheet.functions group. If Column F has information check Column AF and AY for information If Column AF and AY are empty delete the rows. Now it is "and/or" Which posting is correct? See reply to other posting. Gord Dibben MS Excel MVP On Thu, 4 Mar 2010 10:51:02 -0800, Louie wrote: I am looking for help getting a macro that works and performs the following steps. Check Column F for information If Column F has information check Column AF and AY for information If Column AF and/or AY are empty delete the rows. Can you help? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Info in F but AF and/or AY no info so delete the rows
I see in other group you have posted that this has been "solved" so I guess
you are OK. Gord On Thu, 4 Mar 2010 12:41:02 -0800, Louie wrote: Sorry Gord the "and/or" posting is correct, I made a mistake. My apologies. "Gord Dibben" wrote: I see you have changed the rules from your earlier posting in worksheet.functions group. If Column F has information check Column AF and AY for information If Column AF and AY are empty delete the rows. Now it is "and/or" Which posting is correct? See reply to other posting. Gord Dibben MS Excel MVP On Thu, 4 Mar 2010 10:51:02 -0800, Louie wrote: I am looking for help getting a macro that works and performs the following steps. Check Column F for information If Column F has information check Column AF and AY for information If Column AF and/or AY are empty delete the rows. Can you help? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to delete blank rows and move data/info | Excel Discussion (Misc queries) | |||
need help w/ macro prompting with info and pasting the info based on user input | Excel Programming | |||
how to delete the 1st letter form a set of rows of info. | Excel Worksheet Functions | |||
I want to delete duplicate rows of similar info and use the lates. | Excel Discussion (Misc queries) | |||
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming |