Entering multiple records in one form

I have my data in the following format:

Date ! Unit ! Account Code ! Product Code ! Description ! Debit ! Credit !

I enter data using a form.

As of now, for each entry i have to type in the date & unit every time. Can't i have a system where for the same date and unit i update say 5 records and excel updates the Account code, product code etc. keeping teh date and unit same ?

Pls Help.

That is just a design issue.

Have some boxes for the static data, put that in a frame say, then create
another frame with 5 instances of the variable data. You will then just
create the database from that input.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Newtonboy" <[email protected]> wrote in
message news:[email protected]...
>
> I have my data in the following format:
>
> Date ! Unit ! Account Code ! Product Code ! Description ! Debit !
> Credit !
>
> I enter data using a form.
>
> As of now, for each entry i have to type in the date & unit every time.
> Can't i have a system where for the same date and unit i update say 5
> records and excel updates the Account code, product code etc. keeping
> teh date and unit same ?
>
> Pls Help.
>
>
> --
> Newtonboy
> ------------------------------------------------------------------------
> Newtonboy's Profile:
http://www.excelforum.com/member.php...o&userid=29582
> View this thread: http://www.excelforum.com/showthread...hreadid=560973
>