copy paste 2 xl files

[horst]

Hey there,

already used the board search but coud´t find a thing that worked out.

My problem:
I hav 2 diferent xls files. 1 Should be my source and 2 the destination.
1 has about ten different sheeds that are updated randomly by somebody else.

I want to write a makro (the button has to be placed in file 2) that copys the entire data from all sheeds in file 1 to only one sheed in file 2.

Can somebody plz help? I´m absolut newby to VB so some explanations are very welcome too

thx horst

 

[ravishankar]

it is possible to write a simple macro
but you have to tell us how is your raw data (how many columns, rows and cells and sheets) and how you want it compiled in the second workbook

ravi