It has been a while since I needed to ask a question, but here I am again ...
Don't think it's hard, but have been working on this for two days already and it's starting to annoy me. I will explain as good as I can.
I have a workbook, let's call it the source workbook. There is a range of cells (let's say C2 till E2) that all have tabnames from a different workbook in there (these are filled in by the user). Let's use the names Brazil, USA and China as an example.
I want VBA to go to a different workbook ("Actual Data"), select the 3 tabsheets there (Brazil, USA, China) and copy it to a new workbook.
Difficulty might be : the range of cells can be different in length. It might be two cells (C2 till D2) depending on how many cells my user has filled in.
That's my main problem.
What my macro also does, is go to the next row in the source workbook, and do the same thing for the next row (so take a range, for this example C3 till F3, go back to the Actual Data file, copy these 4 tabsheets to a new workbook and so on ...
Anybody that can help me here ? My eternal gratitude.
Don't think it's hard, but have been working on this for two days already and it's starting to annoy me. I will explain as good as I can.
I have a workbook, let's call it the source workbook. There is a range of cells (let's say C2 till E2) that all have tabnames from a different workbook in there (these are filled in by the user). Let's use the names Brazil, USA and China as an example.
I want VBA to go to a different workbook ("Actual Data"), select the 3 tabsheets there (Brazil, USA, China) and copy it to a new workbook.
Difficulty might be : the range of cells can be different in length. It might be two cells (C2 till D2) depending on how many cells my user has filled in.
That's my main problem.
What my macro also does, is go to the next row in the source workbook, and do the same thing for the next row (so take a range, for this example C3 till F3, go back to the Actual Data file, copy these 4 tabsheets to a new workbook and so on ...
Anybody that can help me here ? My eternal gratitude.