Excel 2003 Formulas and Functions

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?
 
C

CurlyDave

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
overwrite specific 'quick parts' - HELP! 1
Integrating information from Word to Excel (not mail merge) 1
Word doc keeps changing to ALL CAPS 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Excel does not accept text format! 0
Excel - Wich Function should I use? 1
Merging from an Excel file with graphics 1

Top