One_Wbk from One_Tab to Wkb's -> One_Tab each Wbk

Hi.
this brilliant code filters the main guide and creates multiple tabs (based on column B).
How to adapt this code so that instead of creating tabs, enter the data within different books in their respective tabs?

Please Login or Register  to view this content.

Att

Hi friends, someone understand my question?

Thanks

Hi, someone can help me?

Thks

Hi...help please...!!

Hi, marreco,

instead of pushing the thread you should go through to find out if all necessary information is delivered: where is the code located, where are the workbooks located, is there more than one worksheet in each workbook, where do the names for these come from, are they identical to the names in Column B of the distribution workbook?

Code is untested:

Please Login or Register  to view this content.

And it really would be helpful if you provided all subs referred to in the code you posted.

Ciao,
Holger

Hi. i try explanation.

look my picture file, maybe you understand..


Thank you!!

Hi, marreco,

these are just two minor changes which you could have figured out by yourself as they have been useed in the opening of the workbook.

Instead of

Please Login or Register  to view this content.

the code should read like

Please Login or Register  to view this content.

And for the other part it was

Please Login or Register  to view this content.

and it should be

Please Login or Register  to view this content.

But Iīm afraid the graphic does not explain how to handle the case of misstyping or additional spaces or the situation if no workbook would be present.

Ciao,
Holger

Thanks, but i have 130 files to open, is possible open paste each files and close files (in background)?

Hi, marreco,

the information about the number of files would have been essential on the opening post as that would have definitely kept me away from even thinking about any kind of solution. I donīt have a clue on what you are trying to achieve and why you think it must be done the way that you ask it to be done, and Iīm lost if I canīt spot that well. There may be other ways to solve your problem but Iīm afraid I canīt see them as no information about the whole project has been given.

is possible open paste each files and close files (in background)

Not as far as I know because you would have to use that for the whole instance which would lead to the same pitfall: the idea might work for say 10 to 20 files but with more you would need to implement some API and a loop to determine if the workbook to write to has been closed in order to proceed with the next workbook.
And working with a second or more instances of Excel would maybe solve the problem to hide the instance in the tray but would open up the problem of copying between these instances as you may not directly do that between two or more instances (if I remember correctly). And you would have to spot the closing of each opened file as well (especially in only one other instance).

I still donīt understand if you want to copy over just the information from the main workbook (and delete the present data prior to that) or if you want to amend the data (which would ask for a logic to exclude duplicates).

Ciao,
Holger

my friend I'll give up this topic.
Thank you for your help