bramblepants
New Member
- Joined
- Jan 24, 2022
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
Hello, I have searched for this macro but can't quite find something that fits what I need. I would therefore appreciate some help with creating a macro that will:
Can anyone assist please?
- Prompt someone to choose an Excel file
- Open the Excel file and in the 'IT Dep Summary' sheet, any rows in range D11 to D111 that contain the word "Reports", copy the data from columns B, C, D, E, F, H for the corresponding row
- Clear and then paste the data from Step 2 into a worksheet named "Reports", starting at cell C6
- In the same 'IT Dep Summary' sheet, any rows in range D11 to D111 that contain the word "Calculations" or "Automated Controls", copy the data from columns B, C, D, E, H for the corresponding row
- Clear and then paste the data from Step 4 into a worksheet named "IT Dependencies", starting at cell C6
Can anyone assist please?