| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting formula in the cell below
Hi,
Sorry about the accidental unfinished post earlier. The user enters a value in A1. B1 has the formula =A1*2 The requirement is an automated way of inserting/copying the formula in B1 to B2 as soon as the user enters a value in A1. I can as well copy the formula down column B, but the file size becomes very large. I have done this before using worksheet change event. Is there a non- VBA/non-Macro way to do this? Thanks in Advance for the Help. Regards, Raj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting formula in the cell below | Excel Worksheet Functions | |||
| Problem After Inserting Cell Formula | Excel Discussion (Misc queries) | |||
| Inserting a cell changes my formula values | Excel Worksheet Functions | |||
| help with inserting a cell value into a named formula | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
![Raj[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
