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