VBA/Macros to Control Active Cell

[914Fan]

Hello To Everyone Taking A Look At This,

First off, I must say I am very thankful for this forum and John Topley for the Wile E. Coyote, Super Genius help he was able to provide. I hope I can find another Super Genius to help me with VBA/Macros code. And I must let you know I know nothing about it. I have successfully screwed up 4 attempts of creating code, once while watching a YouTube video. Doom on me!

Overview, a user enters data into the RO-CT and Daily Database sheets (I have populated June 1-4 to provide a working sample). Then on the Daily Report sheet the user performs one action, enters a date in cell B2 and the entire Daily Report becomes populated by date, pulling and calculating the information from both database sheets.

The issue at hand is the way in which the active cell moves down the page when hitting the enter key and the obnoxious scroll to get to the 1500th row to enter the next bit of data as this database grows.

On the RO-CT Database Sheet:
1 Upon opening the active cell will always be A2
2 Upon hitting the Enter key the active cell will move to column B, then C, then D, and so on until Q (Tax) when the entry is considered completed (Ignore column R (Total) , it is just a SUM column for error checking).
3 When cell in Column Q (Tax) is active hitting the Enter key will 1. Push data entered in row 2 down to row 3, and 2. Reset the active cell back to A2, ready to enter the date from the next invoice.
Lastly, can RO/CT Number Column be coded to always capitalize (defiantly) even if it needed to be moved in the future (icing on the cake)?

On the Daily Database Sheet:
1 Upon opening the active cell will always be A2
When working in the Customer Collection Section
2 Upon hitting the Enter key the active cell will move to column B, then C.
3 When cell in Column C (Amount) is active hitting the Enter key will 1. Push data entered in row 2 down to row 3, and 2. Reset the active cell back to A2, ready to enter more data.
When working in the Cash Paid Out Section
4 When cell E2 becomes active hitting the enter key the active cell will move to column F, then G.
5 When cell in Column G (Amount) is active hitting the Enter key will 1. Push data entered in row 2 down to row 3, and 2. Reset the active cell back to E2, ready to enter more data.
When working in the Final Section
6 When cell I2 becomes active hitting the enter key the active cell will move to column J, then K, and so on to column N.
7 When cell in Column N (Bank Deposit) is active hitting the Enter key will 1. Push data entered in row 2 down to row 3, and 2. Reset the active cell back to I2, ready to enter more data.

The overall idea is to have each section act or feel as if it is its own little mini database even though it is contained on a single sheet.

I know for the most part most of this is a repeat of the same code with different cell references and for someone in the know this is probably a joke; however, I appreciate you for taking a look at it.

Thank you.