Place Valuse in Cell depanding on another

  • Thread starter Thread starter Gerry
  • Start date Start date
G

Gerry

If C2 is blank then put value of B2 into C2 otherwise
leave C2 as it is. All data type are the same. Can anyone
help me with this please.
 
One way:

With Range("C2")
If IsEmpty(.Value) Then .Value = .Offset(0, -1).Value
End With
 
Many Thanks for this.
Now I want to replicate this down the column.

Can you assist.

Gerry
 
One way:

Dim rCell As Range
For Each rCell in Range("C2:C" & _
Range("C" & Rows.Count).End(xlUp).Row)
With rCell
If IsEmpty(.Value) Then .Value = .Offset(0, 1).Value
End With
Next rCell
 
You must log in or register to reply here.

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

Conditional format if difference in cell values greater than 0.50% 1
How to add conditional formating on depand on another cell 1
Named cells in an array to a column and to a row 3
Data entry for fixed cell ranges 5
Sumproduct & VBA 4
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
CONCATENATE code 2
Send data to another workbook 1

Back
Top