Hi there,

I have a worksheet ("Results") that has several rows of data - in specific
columns. I now need to add a specific value into the blank columns of these
rows of data:

Befo
A B C D E
1 coke 24 xxx
2 coke 18 xxx

After
A B C D E
1 coke TRUE 24 xxx
2 coke TRUE 18 xxx

The specific value will be the same on every row. I am able to add this
value to every line regardless of whether there is data in that row, however,
I ideally only want it when there is data in row.

Can someone help me please? If I have been unclear, I will be more than
willing to provide more information should it be required.

Regards

Hi,
If I didn't misunderstand this formula should work

=IF(COUNTA(C8:E8)0,"TRUE","")

if any of the cells in the row have data will enter True otherwise will be
blank

"PVANS" wrote:

Hi there,

I have a worksheet ("Results") that has several rows of data - in specific
columns. I now need to add a specific value into the blank columns of these
rows of data:

Befo
A B C D E
1 coke 24 xxx
2 coke 18 xxx

After
A B C D E
1 coke TRUE 24 xxx
2 coke TRUE 18 xxx

The specific value will be the same on every row. I am able to add this
value to every line regardless of whether there is data in that row, however,
I ideally only want it when there is data in row.

Can someone help me please? If I have been unclear, I will be more than
willing to provide more information should it be required.

Regards

Try this:

Sub PutValue()
Dim specific As String
Dim columnn As String
Dim n As Long, i As Long
specific = "TRUE"
columnn = "C"
n = Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To n
If Application.WorksheetFunction.CountA(Rows(i)) < 0 Then
Cells(i, columnn).Value = specific
End If
Next
End Sub
--
Gary''s Student - gsnu201001


"PVANS" wrote:

Hi there,

I have a worksheet ("Results") that has several rows of data - in specific
columns. I now need to add a specific value into the blank columns of these
rows of data:

Befo
A B C D E
1 coke 24 xxx
2 coke 18 xxx

After
A B C D E
1 coke TRUE 24 xxx
2 coke TRUE 18 xxx

The specific value will be the same on every row. I am able to add this
value to every line regardless of whether there is data in that row, however,
I ideally only want it when there is data in row.

Can someone help me please? If I have been unclear, I will be more than
willing to provide more information should it be required.

Regards

I'm not completely clear on what you are looking to do. Is Column C the only
column that you want to put the word TRUE in or did you want to put that
word into each blank cell on a row containing some data? Will any column
(I'm thinking either A or B) always have data in them when the row contains
data?

--
Rick (MVP - Excel)


"PVANS" wrote in message
...
Hi there,

I have a worksheet ("Results") that has several rows of data - in specific
columns. I now need to add a specific value into the blank columns of
these
rows of data:

Befo
A B C D E
1 coke 24 xxx
2 coke 18 xxx

After
A B C D E
1 coke TRUE 24 xxx
2 coke TRUE 18 xxx

The specific value will be the same on every row. I am able to add this
value to every line regardless of whether there is data in that row,
however,
I ideally only want it when there is data in row.

Can someone help me please? If I have been unclear, I will be more than
willing to provide more information should it be required.

Regards