It has been some time since I last looked at any VBA and most of what I do know has been self taught and learned from here and various web searched and samples.

And I’m trying to create a userform that includes a listbox of all worksheet names. And then the user will choose another workbook, call in workbook B that should have the same identical worksheet names. The script would then look at items/worksheets the user chose from the listbox, and then for each of those worksheets, look in the Workbook B and copy specific ranges from each worksheet into the existing worksheet.

Essentially, I want to copy/paste special value various data, worksheet ranges from one workbook to another. The 2 workbooks should always be identical with the same worksheets. I really cannot copy the entire worksheet from one to the other as there are a lot of formulas and named ranges involved and I think that would begin break various other things in the workbook.

Below is my current userform code that I have from some past help/code, and this will generate the listbox and create an array of the sheet names selected. But I’m stuck from there on how open the other workbook to compare sheetnames and then copy/paste special value.

Please Login or Register  to view this content.