| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. -- Newtonboy ------------------------------------------------------------------------ Newtonboy's Profile: http://www.excelforum.com/member.php...o&userid=29582 View this thread: http://www.excelforum.com/showthread...hreadid=560973 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering multiple records in one form
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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return multiple records matching multiple criteria | Excel Worksheet Functions | |||
| Is there a function to consolidate multiple records into one recor | Excel Worksheet Functions | |||
| Multiple team "All-Play" Won, loss, tie records | Excel Worksheet Functions | |||
| Entering same data into multiple cells | Excel Discussion (Misc queries) | |||
| Entering Data in multiple cells on one sheet & having it auto upda | Excel Worksheet Functions | |||
Linear Mode
