Hi Hyderziaee,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
d...