Excel 2003 Formulas and Functions

  • Thread starter Thread starter caroline
  • Start date Start date
C

caroline

I have one workbook with 2 worksheets a log and a form, I want to type info
in a log and have it transfer to form. save the form then go to the next line
of the log type info and have it overwrite on the form. Can this be done. if
so How?
 
I have one workbook with 2 worksheets a log and a form, I want to type info
in a log and have it transfer to form. save the form then go to the next line
of the log type info and have it overwrite on the form.  Can this be done. if
so How?
Click to expand...

=INDEX(Log!A:A,MATCH(9.99999999999999E+307,Log!A:A)) 'displays the
last item in column A in the worksheet Log

=INDEX(Log!B:B,MATCH(9.99999999999999E+307,Log!B:B)) 'displays the
last item in column B in the worksheet Log
 
Back
Top