View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisa Lisa is offline
external usenet poster
 
Posts: 328
Default Create summary sheet of last row of info from other sheets

I have a workbook where each sheet/tab is a project summary. Each row
represents updated info for that project (multiple columns). I am trying to
automate crating a sheet that summarizes all the other sheets' last rows of
data (most current entry). The summary is used for weekly status meetings.
Right now I am doing the copy/paste from all 51 sheets./tabs into the summary
sheet! PS: need response in simple terms since I am not a technowizard : )