transfer data in other sheet with several conditions automaticaly

[Davidk]

hello,

Dear Excell Master

I have an issue, table witch i update weekly, data there are daily base. in column"total amount" here are null as number (0).

I need to create another sheet where data will be automatically transferred with condition that in"total amount" will be no Null (0); when i update initial table additional table in another sheet (sheet 2) will be update automatically with certain condition. is there any tricky formula to help in this issue?

please help


see attached file

thanks in advance

 

[Chihiro]

Use advanced filter copy. Will have far less overhead than formula method.

See link for very detailed tutorial.
http://www.contextures.com/exceladvancedfiltervba.html

Also, read the related tutorials at bottom of the link.