View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
darsg darsg is offline
external usenet poster
 
Posts: 13
Default how do i append 4 differnt worksheets in a new master work sheets

i have got 4 work sheets with same column name e.g.
sheet 1

o/b I/b 3 4 5 6
27/04/05 89 89 233 11779 11779 11779
28/04/05 9999 9999 23324 23324 23324 11755

sheet2

o/b I/b 3 4 5 6
27/04/05 9999 9999 11779 11766 23324 23324
28/04/05 100 89 233 11791 11791 11791


so on
what i want is append all these sheet in a maste sheet with
the resul like
master sheet

o/b I/b 3 4 5 6
27/04/05 89 89 233 11779 11779 11779
28/04/05 9999 9999 23324 23324 23324 11755
27/04/05 9999 9999 11779 11766 23324 23324
28/04/05 100 89 233 11791 11791 11791

is it possible..... one more thing all are with formulas i want values in
master sheet.
thanks