copy/paste help required

riz4u

New Member
Joined
Sep 6, 2014
Messages
4
Dear all i need copy paste help regarding my sheet i want to copy one cell data to all blanks below it,if non blank cell came,its copy its data and paste downwaord to blankt cell in all rows. i want hi write down into below cell and then next bye into below 2 cells and like that in row

e.g
1
Hi
100
2
100
3
100
4
bye
100
5
100
6
100

<tbody>
</tbody>
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Select the data including the blanks

Press F5

Click Special

Tick Blanks, click OK

Press =

Press Up Arrow

Hold down CTRL and press Enter.
 
Upvote 0
it time taking i have hundred on lines

have data(pillow) in column D,i want it paste in blank cell,then slect other non-blank cell and paste data to downword blank cell,and soooo on
D E
pillowcutt
stitch
pack
quilt covercutt
stitc
pack
curtain

<tbody>
</tbody>
 
Upvote 0
t time taking i have hundred on lines

have data(pillow) in column D,i want it paste in blank cell,then slect other non-blank cell and paste data to downword blank cell,and soooo on
D E
pillowcutt
stitch
pack
quilt covercutt
stitc
pack
curtain

<tbody>
</tbody>
 
Upvote 0
Try this macro

Code:
Sub AFill()
Dim LR As Long
LR = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
With Range("D1:D" & LR)
    .SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C"
    .Value = .Value
End With
End Sub
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,114,002
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top