Copy info from one workbook to another?

D

Dennis

I have a problem

I have a workbook with the function i want like a discribe here. The
problem is i want to split the workbook but i don`t know how.

Is it possible to have a main workbook with information from other
workbooks at each worksheet? I have 20
workbooks with information. I would like to have a main workbook with on
sheet1 every row from the
20workbooks with category1, on sheet2 every row from the 20workbooks with
category2, etc, etc. The information
in the 20workbooks in always only on sheet. The Colum in which the data is
has no fix end. I go to fill in the
rows trough a user-form and comes always under the last row.

The mainsheet has to update every time it opens (and if possible a button
on the sheet to update manually)
without opening all the other documents.

I would like to make the connexion with one subsheet an the mainsheet and
then copy the subsheet 20x with the
connexion



SUBSHEET1 SUBSHEET2 SUBSHEET3
Categorie3 Categorie1 Categorie2
Categorie1 Categorie3 Categorie3
Categorie3 Categorie2 Categorie2
Categorie3 Categorie1
Categorie2 Categorie3
Categorie1 Categorie2
Categorie1


MAINSHEET
Sheet1 Sheet2 Sheet3
Categorie1 Categorie2 Categorie3
Categorie1 Categorie2 Categorie3
Categorie1 Categorie2 Categorie3
Categorie1 Categorie2 Categorie3
Categorie1 Categorie2 Categorie3
Categorie1 Categorie2 Categorie3
Categorie2 Categorie3
Categorie3
 
Top