Hi,
I have a workbook with 2 sheets. In 1st sheet there are some data with 6 columns.
I want the entire row to copy to the 2nd sheet if the value of the 5th column of the particular row is equal to "0".
I need to save this second sheet as a .csv file to import it to my accountancy software. If I apply filters to the first page, when I saving the sheet as a csv file, it still shows the hidden unwanted rows as well.
Thanks in advance for your help.
Bookmarks