8 wkshts in wkbk - need cell selection after an entry to go rt in 3, down on bal

[ILoveStMartin]

8 worksheets in 1 workbook.
After an entry on some worksheets want cell section to go down, and on balance want it to go right.
How can I make this happen?

[HaHoBe]

Hi, ILoveStMartin,

codes go into ThisWorkbook:

Please Login or Register  to view this content.

Please mind that the last direction is kept for Excel after the workbook is closed.

Ciao,
Holger

[ILoveStMartin]

Sorry about taking so long to get back to this, but...
Question, do I need to end up with 5 of the down macros and 3 of the right macro's - one for each worksheet?
If so, after I do the Cntr & F11, do I put one in each of the sheets?
Obviously a Total Novice
Thanks you Very Very Much
Bill

[HaHoBe]

Hi, Bill,

add the sheet names to the Select Case (assuming the sheets are Balance, Master and Invoice) like

Please Login or Register  to view this content.

Both these codes go into ThisWorkbook and will work for all worksheets in the workbook.

Ciao,
Holger