Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display rows if conditions met
Hi,
I would appreciate your help with the following. I have a spreadsheet with data in columns A to T. I need a VBA code for the following conditions ... Conditions for Macro: 1. Only display complete row, if cell has "F" in it . "F" is on its own not as part of a word. 2. Where there is a letter "F", replace in final spreadsheet once macro has run, with the word "Alert!" 3. If there is no "F" in the row, and it there is the word "Passport" in column L, HIDE LINE/ ROW 4. If there is no "F" in the row, and it does not have the word "Passport" in column L, SHOW line/ row 5. Sort the whole result, by column "B" Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display rows if conditions met
Sugiero que en la vista previa para impresión de Excel, se coloque el botón
"siguiente" de segundo después de "anterior". "manfareed" wrote: Hi, I would appreciate your help with the following. I have a spreadsheet with data in columns A to T. I need a VBA code for the following conditions ... Conditions for Macro: 1. Only display complete row, if cell has "F" in it . "F" is on its own not as part of a word. 2. Where there is a letter "F", replace in final spreadsheet once macro has run, with the word "Alert!" 3. If there is no "F" in the row, and it there is the word "Passport" in column L, HIDE LINE/ ROW 4. If there is no "F" in the row, and it does not have the word "Passport" in column L, SHOW line/ row 5. Sort the whole result, by column "B" Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display rows if conditions met
hi,
sorry i don't understand "roger" wrote: Sugiero que en la vista previa para impresión de Excel, se coloque el botón "siguiente" de segundo después de "anterior". "manfareed" wrote: Hi, I would appreciate your help with the following. I have a spreadsheet with data in columns A to T. I need a VBA code for the following conditions ... Conditions for Macro: 1. Only display complete row, if cell has "F" in it . "F" is on its own not as part of a word. 2. Where there is a letter "F", replace in final spreadsheet once macro has run, with the word "Alert!" 3. If there is no "F" in the row, and it there is the word "Passport" in column L, HIDE LINE/ ROW 4. If there is no "F" in the row, and it does not have the word "Passport" in column L, SHOW line/ row 5. Sort the whole result, by column "B" Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a cell display blank under certain conditions? | Excel Discussion (Misc queries) | |||
If statements, conditions and cell display | Excel Programming | |||
Count Rows when certain conditions are met | Excel Discussion (Misc queries) | |||
how to display different content depends on some conditions? | Excel Programming | |||
display rows that meet two conditions | Excel Programming |