VBA Code to Copy

[Herbiec09]

Hi All,

I am looking for assistance with a unique copy and paste problem. Can someone assist with a code to copy data into the areas that I have highlighted in green from the rows above. I have put the excel doc on google docs, with the link https://docs.google.com/file/d/0B91u5j5KZfFYaUtnMlBFckRBZTQ/edit?usp=sharing

Many Thanks

Herbert

 

[Momentman]

1. Highlight all cells
2. press F5 (Go to)
3. click special
4. select blanks (to select only blank cells), click Ok
5. in any of the cells highlighted, type the formula = "the cell above it" e.g if in cell A23, type = A22
6. press ctrl+enter not just enter to fill all highlighted cells
7. you can then paste as values

 

[Herbiec09]

1. Highlight all cells
2. press F5 (Go to)
3. click special
4. select blanks (to select only blank cells), click Ok
5. in any of the cells highlighted, type the formula = "the cell above it" e.g if in cell A23, type = A22
6. press ctrl+enter not just enter to fill all highlighted cells
7. you can then paste as values

Thanks bro, but I was looking for a VBA code. New link is https://docs.google.com/a/talarius.co.zw/file/d/0B91u5j5KZfFYTWZPM2Ffcl9MMEU/edit?pli=1

Many Thanks

 

[Momentman]

I kinda hard coded the range. Try it on a copy of the data

Sub Macro1()
    Range("A4:C27, F4:F27").Select
    Selection.SpecialCells(xlCellTypeBlanks).Select
    Selection.FormulaR1C1 = "=R[-1]C"
    
End Sub