View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vsn Vsn is offline
external usenet poster
 
Posts: 21
Default Many to One (Excel sheet)

Hi all,

I am not so familiar wit VBA for excel, more with the Access version. That
is as well were my question comes from. Any help is appriciated.

I have an excel file which contains 37 (!!) sheets, all in the same data
format full with tons of data. I would like to, automaticaly with some code
if possible, copy all the contents of each sheet to one new (to be created
sheet). Is this do-able?

Afterward I will import the newly created sheet into an Access table and
create a usefull datebase around it.

Thx alot, cheers,
Ludovic