In a folder I have multiple files all with the same format
In each file i have a tab called "statement"
data have to be pulled from B,C,D,E,F and G columns
once file directory is selected
from all the files of statement tab
Copy Rows of B,C,D,E,F and G rows which is not 0.00 or copy all with values and 0.00 can be deleted in output file
In an output file copy file name and paste as values what has been copied in the above step
please let me know if I am not clear.
attached input file and sample output in the output tab
I Could see some help in below sites but do not know how put across