Need code or just guidance!!
 

I need to be able to concatenate blank cells without it showing a zero for
the cells that were true from an if statement but blank, or be able to record
a macro that prompts me for a cell reference or can find a range of
cells(A:AK) based on AL having certain text in it. Can anyone help??? I am
ready to scream.

Need code or just guidance!!
 

Question...

Are you wanting to concatenate all rows or just the ones that meet certain
criteria?


"Jessica" wrote in message
...
I need to be able to concatenate blank cells without it showing a zero for
the cells that were true from an if statement but blank, or be able to
record
a macro that prompts me for a cell reference or can find a range of
cells(A:AK) based on AL having certain text in it. Can anyone help??? I am
ready to scream.

Need code or just guidance!!
 

just the ones that meet certain criteria

and the second part of the question I am really struggling with!1
"Mark Ivey" wrote:

Question...

Are you wanting to concatenate all rows or just the ones that meet certain
criteria?


"Jessica" wrote in message
...
I need to be able to concatenate blank cells without it showing a zero for
the cells that were true from an if statement but blank, or be able to
record
a macro that prompts me for a cell reference or can find a range of
cells(A:AK) based on AL having certain text in it. Can anyone help??? I am
ready to scream.