Need Help Please!

[Santosh080]

Hi Friends

I need some help in excel. Yesterday i face some problem in excel. I have file like below,

Here i want a formula in A2 cell so that when drag that formula i will get result like below,

I have no knowledge in VBA so please anybody help me. I need this in my office.

Thanks

 

[Fluff]

How about

Sub Santosh()
   With Range("A1", Range("A" & Rows.Count).End(xlUp))
      .SpecialCells(xlBlanks).FormulaR1C1 = "=r[-1]c"
      .Value = .Value
   End With
End Sub

 

[VBE313]

What is the logic behind this?

 

[Santosh080]

thanks Fluff for help
Actually i have very little knowledge about VBAcodes . So, can it possible by simple function like IF or any other.
( I do not want to color the cell)

 

[Fluff]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.

 

[Santosh080]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.

I have updated my profile. I am using Office 2016 in windows 7.

 

[Fluff]

Many thanks for that.
The simplest way is just to put =A1 into A2 & fill down to A4
then put =A5 into A6 & fill down.
Etc, etc

 

[Santosh080]

Many thanks for that.
The simplest way is just to put =A1 into A2 & fill down to A4
then put =A5 into A6 & fill down.
Etc, etc

Thanks. I have tried that but this will take more time because i have huge database.

 

[Fluff]

In that case have a look here

Fill in blanks in Excel with value above/below, fill empty cells with 0

See how to quickly select all empty cells in Excel and fill them with 0 or with the value above/below a blank cell.

www.ablebits.com

 

[Santosh080]

In that case have a look here

Fill in blanks in Excel with value above/below, fill empty cells with 0

See how to quickly select all empty cells in Excel and fill them with 0 or with the value above/below a blank cell.

www.ablebits.com

Thanks I will try it.?
I have found a solution just now but I have not tried yet due to some other work. I don't know it will work or not.

The function is

=IF(ISBLANK($A2), $B1, $A2)

Here the person told that function is to use in new column.