The above solution did work and help. So first sheet is pivot table sheet in excel and 2nd is the normal one. I schedule daily report sending to FTP from 1st sheet. Now the problem is, everyday same day data is going. I did schedule the report but everyday it should go different data but it is going for same day data everyday.
Before pivot table option, it was going different files everyday but with empty rows. Now I implemented pivot option to get rid of empty rows then same day data is going to FTP server. Can you please help in what mistake I might be doing ?
Hi, I am also having same problem of extra empty rows. Could you please explain the steps in detail about "creating a pivot table and form the exact same table through it". I tired but did not work. In case, I might be doing wrong. Thanks