View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mary Mary is offline
external usenet poster
 
Posts: 190
Default copying and paste data from each worksheet to a summary work sheet

hello all,
I have a work book that i stored data. There is 30 tabs or sheets(i:e each
sheet is used to store a day activities). At the end of the month i would
like to summarized each tab's or sheet data on the summary sheet(the summary
sheet is the last tab on the wookbook).
I would like to have a macro that copies each entries on each sheet and
store them on the summary page then sort the information in alph. I have
tried record macro but that does not work. i will appriecate and help
thanks in advices