Conditional Formatting

[A2B]

i need to move cells down as soon as entered...

several hundred numbers will be filed and instead of scrolling down the page. i would like the numbers to move down one cell after entered.

Before:

A2 = $125
A3 = $75
A4 = (empty)

Is there a format i can use to move all rows down when i enter a new number into A1...

New number entered is $200

After:

A2 = $200
A3 = $125
A4 = $75

I can not just enter a new row as column B - O are also being used...

[protonLeah]

Please Login or Register  to view this content.

To insert the macro:
1. Ribbon.Developer
2. Visual Basic
3. In the Project Explorer Pane (left pane) double click the desired sheet,
4. Paste the code above in the Code pane (right pane)