Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Cell focus base on value in first Cell
Hi All,
I'm using Excel 2007 & I have a spreadsheet that requires user input in rows for various criteria and produces a report based on that information. The first cell in column D (D8) contains a value that I would like to use to allow information to be entered in that row. Example D8=6 Data can be entered in the next 6 cells in that row, after the 6th data is entered the cell focus is automatically changed to D9 and the process starts all over again for row 9. the cell value of D9 is used to allow the cell data to be entered until that value is reached then back to the next row D10. Any help you can give would be greatly appreciated! Thanks, B |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Cell focus base on value in first Cell
On Nov 10, 2:38 pm, pixelpounder wrote:
Hi All, I'm using Excel 2007 & I have a spreadsheet that requires user input in rows for various criteria and produces a report based on that information. The first cell in column D (D8) contains a value that I would like to use to allow information to be entered in that row. Example D8=6 Data can be entered in the next 6 cells in that row, after the 6th data is entered the cell focus is automatically changed to D9 and the process starts all over again for row 9. the cell value of D9 is used to allow the cell data to be entered until that value is reached then back to the next row D10. Any help you can give would be greatly appreciated! Thanks, B bump |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
emptying the contets of a cell base on the value of another cell | Excel Worksheet Functions | |||
Cell to display text from cell on focus?? | Excel Programming | |||
unique values in a cell base on another cell | Excel Discussion (Misc queries) | |||
Cursor Keys does not change cell focus | Excel Discussion (Misc queries) | |||
change tab color base on cell value | Excel Programming |