Create summary tab of last entry/row on all tabs in workbook

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

I am tracking projects in a workbook. I have a tab/worksheet for each
project. For a weekly status meeting I create a spreadsheet that has the
last entry/row from each tab. Is there a way to program so I do not have to
copy/paste from each tab each week? I do add and delete tabs/projects from
time to time. PS- not very adept at the technical details so need to respond
to me in simple terms : )
 
You might want to submit your question to an Excel NG since I don't see
anything in your question regarding MS Access.

IMHO, I would move the workbooks to an Access database rather than using
Excel ;-)
 
Back
Top