Populate cells with MsgBox imput - Help complete VBA Macro

[zan1989]

Hello There! So i managed to create a macro that imports data from another file and it works great - it finds first and last cell pastes in the workbook (also finding first available cell).

This is the code:

Please Login or Register  to view this content.

Now I want to change it to be able to ask a question during the macro "What number you want to add?" and then add this number in the last column, (see the image for more information)
And so I did find this:

Please Login or Register  to view this content.

And I know that somehow I have to make a command that puts this into the first and last row...I just don't know how...
Something like this would probably make sense:

Please Login or Register  to view this content.

Anyone who coukd help me optimize it? so it adds a number for each last column? (in my sheet its column DD)

This is how I want it to work:
Picture howitshould.png

[WideBoyDixon]

Logically, you are copying (lr-1) rows from the book you've opened and pasting them into row (lrtarget+1) into your original workbook. This makes the last paste line in your original workbook of (lrtarget+lr-1). With this in mind, you could so something like this:

Please Login or Register  to view this content.

WBD

[zan1989]

Wow, you are a god! Thank you so much.