put data in a blank cell if condition met

  • Thread starter Thread starter ditchy
  • Start date Start date
D

ditchy

hi there excellers
i have two columns that have data in both or just column a
a b
row1 0:03:15 0:03:20
row2 0:03:35
row3 0:04:15 0:04:16
what i need is when a cell in column b is empty insert corresponding cell
in column a. the cells are time formated. finished project should be like so
a b
row1 0:03:15 0:03:20
row2 0:03:35 0:03:35
row3 0:04:15 0:04:16
any help much appreciated T.I.A
regards Ditchy
 
One way:

Select column B. Choose Edit/Goto. Click Special, then select the
Blanks radio button and click OK.

With the blanks selected, type "=" (without quotes), then left
arrow. Type CTRL-Enter.
 
try a for/each loop

for each c in [b2:b200]
if c="" then c.value=c.offset(,-1)
next
 
Don Guillett said:
try a for/each loop

for each c in [b2:b200]
if c="" then c.value=c.offset(,-1)
next

ditchy said:
hi there excellers
i have two columns that have data in both or just column a
a b
row1 0:03:15 0:03:20
row2 0:03:35
row3 0:04:15 0:04:16
what i need is when a cell in column b is empty insert corresponding cell
in column a. the cells are time formated. finished project should be like so
a b
row1 0:03:15 0:03:20
row2 0:03:35 0:03:35
row3 0:04:15 0:04:16
any help much appreciated T.I.A
regards Ditchy
Click to expand...
Click to expand...

Thanks Don, perfect for what I need. Tried the suggestion from JE
McGimpsey but I could not get it to work. Thank you both for your help
regards Ditchy
 
Back
Top