Hi all,
I hope you can help me with the following code I need.
I have 10 different WBs in a folder, let´s say C:\Users\Downloads.
I would like to have a code that goes into every closed WB in the folder and copy only the green colour sheets into a new WB.
For example:
WB 1 name: Debt
Number of sheets: 5 sheets in the WB, only one sheet is green coloured, called "Summary".
WB 2 name: Assets
Number of sheets: 3 sheets in the WB, only one sheet is green coloured, called "Assets".
Final result:
I would like to create a new WB, with only the two sheets green colour, in this case, "Summary" and "Assets".
Thanks in advance for your help!
I hope you can help me with the following code I need.
I have 10 different WBs in a folder, let´s say C:\Users\Downloads.
I would like to have a code that goes into every closed WB in the folder and copy only the green colour sheets into a new WB.
For example:
WB 1 name: Debt
Number of sheets: 5 sheets in the WB, only one sheet is green coloured, called "Summary".
WB 2 name: Assets
Number of sheets: 3 sheets in the WB, only one sheet is green coloured, called "Assets".
Final result:
I would like to create a new WB, with only the two sheets green colour, in this case, "Summary" and "Assets".
Thanks in advance for your help!