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