vikas_newports
Board Regular
- Joined
- May 26, 2016
- Messages
- 121
- Office Version
- 365
- Platform
- Windows
Hello
I have multiple files with same format and I want to perform below work for every file
Copy E2 to Macro file Sheet 2 (A1)
Apply filter on Row 9(header)
filter the dates after 31-mar-2021 on Column C
on filtered data copy the amounts from Column F without Header and paste as transpose to new macro file Sheet2 (B1)
I have multiple files with same format and I want to perform below work for every file
Copy E2 to Macro file Sheet 2 (A1)
Apply filter on Row 9(header)
filter the dates after 31-mar-2021 on Column C
on filtered data copy the amounts from Column F without Header and paste as transpose to new macro file Sheet2 (B1)