View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Khoshravan Khoshravan is offline
external usenet poster
 
Posts: 211
Default consolidate over 50 sheets by Macro

I have same set of data for 50 runs of a program, each stored in a sheet. so
I have 50 sheets naming sheet1 to sheet50. Column headings are same for all.
I have to consolidate them into one sheet. Instead of going over 50 sheets to
add them in consolidation window, is it possible to perform it by MAcro to go
over 50sheets?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan

consolidate over 50 sheets by Macro