Display rows if conditions met

M

manfareed

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,
 
R

roger

Sugiero que en la vista previa para impresión de Excel, se coloque el botón
"siguiente" de segundo después de "anterior".
 
M

manfareed

hi,

sorry i don't understand



roger said:
Sugiero que en la vista previa para impresión de Excel, se coloque el botón
"siguiente" de segundo después de "anterior".
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide/Show rows based on Conditions 3
How to clear prior search terms from Navigation Pane 0
Mail Merge Help 1
hiding blank rows 3
Delete Rows with Conditions 0
Need Help with a VBA subroutine 0
Cumulative formula for word table 0
Template with fields and premade texts.. 0

Top