View Single Post
  #1 (permalink)  
Old April 1st, 2015, 05:17 AM
baskar5353 baskar5353 is offline
Registered User
 
Join Date: Mar 2015
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default various worksheet from various work book into one workbook

Hi,
I need worksheet from various workbook into one workbook as separate separate sheet
3 excel are there each excel contain many sheets i need only 3 sheets with new excel
example:
1. count(excel name) in that sheets name(Name,valid,invalid)
2.Process(excel name) in that sheets name(Per process,Post process,End process)
3.Closed(excel name) in that sheets name(Past,Overhead,Maintain)
in that i need only 3 sheet with new excel as
In new excel i need as sheet1 as(valid,from excel count) sheet2 as (End process, from excel process) sheet3 as(Overhead from excel closed)
i need this each sheets as separately with in one excel
can you help me for this
Thanks & Regards
Baskar