Copy paste several sheet's

[Birnen]

Hello

Is it possible to make a VBA to copy and paste several different sheet's from diferent workbook's with several names (the workbook name is the same of da sheet), just to a sheet of another workbook.

Cumps

[alansidman]

Simple answer is yes. If you post a specific question, with a sample worksheet(s), then we could probably give you specific response.

[Birnen]

Simple answer is yes. If you post a specific question, with a sample worksheet(s), then we could probably give you specific response.

Here goes example workbook's. the Livro10, Livro20 and livro30 most go to workbook Principal.

cumps

[Birnen]

I found this excel here in the forum, and I am not able to do what I want. I managed to change the code for the macro to fetch the address of the spreadsheet workbook where the information are to copy and paste, that address is entered from a cell. I would do the same with the name of the spreadsheet to copy the way I did to the address of the workbook.

someone can give me a hand?

best regards

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Birnen]

Maybe:

Please Login or Register  to view this content.

See my last post, above.

[Birnen]

Can any one help me.
Please

Regards

[Birnen]

Can any one help me.
Please

Regards

[alansidman]

Have you tested John's code? Does it work for you? If not, what do you want to do that it doesn't do for you?

[Birnen]

yes. it work's.

but I have many worksheet's to copy, so for that it becomes a little slow.

[alansidman]

Looking at your code, instead of changing the value in K3, you could list all the values (paths and files) in column K and then create a loop to do the copy and paste. That would speed things up, but it will require you to populate all the file names and paths.