Hello All, I am new to both this forum and VBA. I hope you can assist me with the below.
I would like to write a code that allows me to do the following:
Tufela
I would like to write a code that allows me to do the following:
- A prompt to select the required workbook bybrowsing through the folder. The workbook will be saved in different locationshence the flexibility required.
- The macro will then need to select all and copyall the contents from an assigned worksheet within the workbook from abovedirectly without opening the workbook.
- Then paste all or paste special the above into aparticular worksheet of the active workbook.
Tufela
