Macro to move cursor to diffrent places in a row

[wish2excel]

Hi Guys

I am trying to do some data entry work in a excel sheet, I am trying to make my work easier instead of moving around the sheet using arrow keys i would like to run a macro, which helps me to move around the sheet. I will try to mention the cursor movements step by step.

I have columns from A to Q

A = Serial No: ( I will Type That)
B = Current Date (When I type Serial No: in Column A, It should come automatically)
C = Current Time (When I type Serial No: in Column A, It should come automatically)

Thats First part
Then in Column I if more than 2,then cursor should go to K,if less than 2 go to J
Then in Column K if YES, then cursor should go to L, If K is NO then go to O
Then in Column J if more than 2, Then cursor should go to P,If less than 2 got to Q
Then in Column M if the text value or list value( Which I have not decided yet) is 'AUC' then cursor should go to N

I hope the explanation is OK

Can somebody help me on THIS TASK

Thanks In ADVANCE

[venkat1926]

OPEN AN EXPERIMENTAL SHEET AND TRY THIS EVENT CODE

right click sheet tab and click view code and in the resulitng window copy this event code

Note
[B]the strings like AUC,YES,NO are case sensitive. use capitals always. [/B

after parking the event code and savings the file try all those turns and see whether it does what you want. If there is small glitch I am sure you can modify the event code.


the event code:

Please Login or Register  to view this content.

]

[wish2excel]

Please Login or Register  to view this content.

I have made minor changes to the code but i have one more request,column J get the value using a formula NETWORKDAYS so we dont enter that manually and also Column K gets the value using network days

[wish2excel]

Hello friends I am attaching a new file with the latest changes,there is a problem in Allocation TAT and Booking TAT, this is calculated using Networkdays Formula of entering it manually,but the code works only if its entered manually.it was working fine if it was entered manually. so can some body help me on this