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

smcclure

New Member
Joined
Nov 2, 2011
Messages
2
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
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
You could assign the following to a button on your sheet or put it in the worksheet doubleclick code or before rightclick code.

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
 
Upvote 0

Forum statistics

Threads
1,222,437
Messages
6,166,024
Members
452,008
Latest member
Customlogoflipflops

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