View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Axemaneire Axemaneire is offline
external usenet poster
 
Posts: 2
Default 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!!