K
Karen
Hello Excel experts!
I use Excel 2003.
I have a client who has a workbook consisting of a separate worksheet
for each of his customers, as well as a summary page.
Within each separate worksheet, In column "A", he tracks the last date
that he visited a client and inserts a new row each time that he does.
He'd like his summary sheet (the main page I'm trying to link this data
to) to always reflect this latest "date" row automatically and I'm
really not sure how to do that.
I can link any one particular cell within that column, but I don't know
how have it change dynamically each time I add a new date (in the next
row).
I'm not familiar with macros, but I have a feeling I may have to start
learning in this case! LOL
Any suggestions you might have would be very much appreciated.
Thanks so much!
Karen
I use Excel 2003.
I have a client who has a workbook consisting of a separate worksheet
for each of his customers, as well as a summary page.
Within each separate worksheet, In column "A", he tracks the last date
that he visited a client and inserts a new row each time that he does.
He'd like his summary sheet (the main page I'm trying to link this data
to) to always reflect this latest "date" row automatically and I'm
really not sure how to do that.
I can link any one particular cell within that column, but I don't know
how have it change dynamically each time I add a new date (in the next
row).
I'm not familiar with macros, but I have a feeling I may have to start
learning in this case! LOL
Any suggestions you might have would be very much appreciated.
Thanks so much!
Karen