Inserting formula in the cell below

[Raj]

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

 

[Ashish Mathur]

Hi,

I assume you mean that as soon as the user enters a value in cell A2, the
formula in cell B2 (=A2*2) should get inserted. If that is indeed the case,
then select A1:B1 and press Ctrl+T to convert it to a table. Now when you
enter a value in A2, the formula from the cell above would get copied.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com