Pasting Data Upwards

[alive15]

Good afternoon,


I have some data in cells A1:B10. I want to paste directly into another excel sheet, but fill the data upwards instead of downwards.


For example, I want to paste directly into D80, so B10 = D80 and A10 = C80.


Is there some settings I need to enable or some formula to accomplish this task? The only requirement to fulfill involves pasting the data directly into D80.


The reason for the above requirement includes not actually knowing what row # the data will get pasted into. It could be D77, it could be D120 or D555.


A second reason why I need the above requirement involves using my macro. All of these copying / pasting will be accomplishhed automatically through my macro.


If I can find a solution to my issue, I will complete my macro. Thanks


EDIT: Most importantly, I just need to figure out how to do this with mouse movements; then I can create a macro to automatically do this. Thanks.

 

[Fluff]

How about

Sub chk2()

    With Sheets("[COLOR=#ff0000]Exist[/COLOR]")
        Sheets("[COLOR=#ff0000]List[/COLOR]").Range("C80").Offset(-9).Resize(10, 2).Value = .Range("A1:B10").Value
    End With

End Sub

Changing sheets names in red to suit

 

[Rick Rothstein]

s there some settings I need to enable or some formula to accomplish this task? The only requirement to fulfill involves pasting the data directly into D80.

The reason for the above requirement includes not actually knowing what row # the data will get pasted into. It could be D77, it could be D120 or D555.

So, if I read the above correctly, you are not always pasting into cell D80, correct? You need the routine to work for any cell in Column D, correct? If so, and since this is going to be done from a macro, how are you determining the row in Column D to start your upward pasting from (that is, how do you know to start at D80 or D77 or D120, etc.)?

 

[SpillerBD]

There's a technique using Goto, Blanks and array formula entry to Fill down. Used to be needed by some wanting to Fill down in Old Pivot Tables.
http://mrexcel.com/articles/fill-pivot-blank-cells.php

Normally shown as a Fill Down, but changing the referencing will create a fill up.