Auto fill form from a worksheet

[Lucybella]

Using Excel 2000 Professional for work
I have a worksheet (Log) that has 7 columns, the first column is a list of
pre-set numbers for reports. The second worksheet is an Incident report
form. 6 of the 7 colums on the log are also on the report form. We open the
log sheet which has pre set Report numbers, then fill in type of incident,
location of incident, start date and time. Then open the report form and add
the same information into the form plus more information not on the Log. Is
there any way to link the 2 worksheets so as the information is added on the
Log it will auto fill on the form?

 

[joel]

the term form could mean a few different things so I'm not sure exactl
what you workbook looks like. Most forms use either Comboxboxes o
Listboxes to enter data (except if it is a worksheet form). th
Listboxes and Comboboxes have a property ListFillRange which can get th
inputs from a worksheet.


Usualy you would have to write a macro to impliment this feature.