Dear experts, please help me out to get the code,
.
I need to write a macro that can do this things :
.
there are 3 files (A,B,C) - contains single sheet each, in a specific folder that need to compile into a single worksheet :
- first, need to filter the years (select 2017,2018 only for all files)
- filter file A (there is one column that need to select as blank), only the row that has blank value on that column is shown (after filtered) that data is then copied.
- copy the entire filtered data of all files A,B,C - (only file A is special case that need extra filter as mentioned above)
into one workbook (paste in sequences - row after row)
- paste all the copied data into a cell that start on A2, as the header need to be remained .
.
lots of thanks, only god can reward your kindness.
.
I need to write a macro that can do this things :
.
there are 3 files (A,B,C) - contains single sheet each, in a specific folder that need to compile into a single worksheet :
- first, need to filter the years (select 2017,2018 only for all files)
- filter file A (there is one column that need to select as blank), only the row that has blank value on that column is shown (after filtered) that data is then copied.
- copy the entire filtered data of all files A,B,C - (only file A is special case that need extra filter as mentioned above)
into one workbook (paste in sequences - row after row)
- paste all the copied data into a cell that start on A2, as the header need to be remained .
.
lots of thanks, only god can reward your kindness.