I have a dream...about userforms and data management.

[Paul987]

Unfortunatly, I don't know how to go about doing this. Currently I have a list of rows, where the user scrolls to the bottom to enter new fields. He enters four fields and then copies down about 10 formulas.
What I need:
I want to create a form on the top of the sheet, where the user enters the four required values, hits "ok", and they will then be transfered to their appropriate positions. Then formuals are also copied down. Then the form clears. Is there a way to do this? Any help would be appreciated. TIA
Paul

[Jim Thomlinson]

You can try clicking on Data -> Form. That sounds close to what you want.
--
HTH...

Jim Thomlinson


"Paul987" wrote:

>
> Unfortunatly, I don't know how to go about doing this. Currently I have
> a list of rows, where the user scrolls to the bottom to enter new
> fields. He enters four fields and then copies down about 10 formulas.
>
> What I need:
> I want to create a form on the top of the sheet, where the user enters
> the four required values, hits "ok", and they will then be transfered
> to their appropriate positions. Then formuals are also copied down.
> Then the form clears. Is there a way to do this? Any help would be
> appreciated. TIA
> Paul
>
>
> --
> Paul987
> ------------------------------------------------------------------------
> Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
> View this thread: http://www.excelforum.com/showthread...hreadid=528585
>
>