View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steph[_3_] Steph[_3_] is offline
external usenet poster
 
Posts: 312
Default Copy contents from all sheets into 1

Hello all. If I have a workbook that have several sheets, how can I copy
the contents of each sheet and paste that one under the other on the sheet
called "Consolidated". So basically I will be consolidating all sheets in
workbook except 'Consolidated' onto the sheet 'Consolidated', one under he
other. Thanks!