Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have created a spreadsheet requiring data to be entered in a set
order. By that I mean the first entry will be in the first blank cell in column "B". On pressing "Enter" I want the focus to move to C, D, E, F then M, N and O. Two questions: How do I get Excel to open with the focus in the first blank cell in column B? How do I set the movement of the focus on pressing "Enter"? The cells between column F and M are calculated cells and do not need to be selected. The cell in column A has the date automatically calculated when data is added to cell B, C or D. Please make your reply simple for me to follow as I am rather ignorant as far as VB is concerned. Orf |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
File associate setting in Excel | Excel Discussion (Misc queries) | |||
Excel 2003 Toolbar Icons are fuzzy and out of focus | Excel Discussion (Misc queries) | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
Fit Selection Setting Doesn't Hold | Excel Discussion (Misc queries) | |||
Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) |