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
hiding blank rows 3
Delete Rows with Conditions 1
Help with sorting data 3
Scrabble Value calculation for Welsh words 0
if multiple conditions are true, then copy the row to a new sheet 2
Macro for adding rows if two different columns have a value 3
Find a value in a sheet and replace it with another value if it matches 8

Top