| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert formulas on data entry trigger
I have a data sheet template that has measurements entered into columns A
(Item), B (Width), C (Height) and D (Quantity). Columns E to L have formulas. Data starts on Row 6. If I enter the formulas into a hidden row (5), how can I have the formulas copied from E5:L5 into E6:L6 when the quantity is entered into column D and the cursor moved to column A of the next row to start the next data entry and so on. Data will vary from a few rows to dozens of rows. Does anyone have a suggestion for a macro based on a selection change in column D from row 6 onward? -- Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Entry and Formulas | New Users to Excel | |||
| Automating Data Entry (Position the cursor, insert row) | Excel Programming | |||
| new row insert on data entry | Excel Discussion (Misc queries) | |||
| How do I protect formulas in a worksheet and allow data entry | Excel Worksheet Functions | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Threaded Mode
