Could you help to create macro on excel? (Copy&Paste loop with A conditon)

[tom8254]

I'm trying to make a macro.....but....I don't have no idea.

Could you help?

I wanna make like that.

Step1. copy just one cell (B14)
Step2. paste the coied cell to A15
Step3. again B15(copy)
Step4. A16(Paste)
Step5. again B16(copy)
Step6. A17(Paste)

Loop~

but if 'Project Total' value in the cell the cell copies excluding.

Could you help me to make the mecro?

Thank you
YB.Shin

 

[My Aswer Is This]

I do not understand this:
but if 'Project Total' value in the cell the cell copies excluding.

 

[My Aswer Is This]

Try this:

Sub Copy_Paste()
'http://www.mrexcel.com/forum/excel-questions/887016-could-you-help-create-macro-excel-copy-paste-loop-conditon.html
Application.ScreenUpdating = False
Dim i As Integer
    For i = 15 To 17
        Cells(i, 1).Value = Cells(i - 1, 2).Value
    Next
Application.ScreenUpdating = True
End Sub
'Copy paste not needed

'No loop example
'Cells(15, 1).Value = Cells(14, 2).Value
'Cells(16, 1).Value = Cells(15, 2).Value
'Cells(17, 1).Value = Cells(16, 2).Value

 

[tom8254]

this is what I want result

I do not understand this:
but if 'Project Total' value in the cell the cell copies excluding.

 

[My Aswer Is This]

Did my script work for you?
if not what did it not do that you wanted

 

[tom8254]

Yeah It works but I don't want the cell(value="Project Total") to copy.
What should I add in the script?? With ~ end with?

Please help me
you are saving my life ^^

 

[My Aswer Is This]

Your original post said copy B14 B15 B16
So is that wrong?

 

[tom8254]

Sorry I forgot it to type '....' first my quetion it missed '.....' . end of the cell is dynamic. Every time changed.

But the form everytime is same.

I want to getthe result like the screenshot.
Copy , paste and it doesn't want to copy that value="Project Total"

If I make you confused Im so sorry.