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?