Only filling in cells that are directly below already-filled cells

[smcclure]

Let's say I have someone enter 4 numbers in the range A1:A4. This will look as follows:

1
2
3
4

I have these numbers automatically enter the cells in a separate row. For example, the numbers go into the range D4:G4 to look as follows:

1 2 3 4

Now here's the important part. Can I have the user enter a NEW set of numbers in the range A1:A4 and have these NEW numbers automatically be entered into the row below the first one (in the range D5:G5), to look as follows:

1 2 3 4
5 6 7 8

In other words, is there a way to have the first row "preserved" and have the second numbers "skip" the first row because it is already filled? That way a user can keep entering numbers into the range A1:A4, and a list will continue to grow as D4:G4, D5:G5, D6:G6 etc. A macro button or something could allow for the numbers to be added to the rows, as long as the macro knows to "skip" to the next row if there is data already in the preceding row. Must one use a macro for this?

Thank you

 

[Jaye7]

You could assign the following to a button on your sheet or put it in the worksheet doubleclick code or before rightclick code.

Range("D5").Select
    Range("D" & Rows.Count).End(xlUp).Select
ActiveCell.Offset(1, 0).Value = Range("A1").Value
ActiveCell.Offset(1, 1).Value = Range("A2").Value
ActiveCell.Offset(1, 2).Value = Range("A3").Value
ActiveCell.Offset(1, 3).Value = Range("A4").Value

 

[smcclure]

That worked perfect!!! Thank you so much!!!!