Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
moving cells in Excel
Hi Guys
Been having trouble with what seemed like a simple macro to write!. I want to have an excel sheet where if a value is entered in Column H; the next cell beside it in column I is selected for data entry. If Data is entered in any cell in I it then moves down a cell and back 1 cell to the next cell in column H. e.g. enter data in cell H1 - I1 becomes active cell Enter data in I1 - H2 becomes active cell Enter datain H2 - I2 becomes active cell etc Your help would be much appreciated!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving text around cells without moving boarder lines | Excel Discussion (Misc queries) | |||
Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
Excel 2002 : Problem in moving along blank cells | Excel Discussion (Misc queries) | |||
excel check boxes moving when excel selected cells pasted in word | Excel Discussion (Misc queries) | |||
Moving from unlocked cells to unlocked cells in an excel form | Excel Worksheet Functions |