View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] tarone@gmail.com is offline
external usenet poster
 
Posts: 11
Default Combin / Merge Multiple Worksheets / sheets into one worksheet / sheet

I have several worksheet in one file

e.g

SHEET1
Name Number Field Qty Age
John 7878 8989 234 32
Peter 7877 23 9 NA
Mike 3433 343 --

Sheet2
Name Number Field Qty Age
Shart 343 343
William 323 52 5

I just want to combine into one worksheet as follows

New Sheet

Name Number Field Qty Age
John 7878 8989 234 32
Peter 7877 23 9 NA
Mike 3433 343 --

Name Number Field Qty Age
Shart 343 343
William 323 52 5

any advice

thanks