filtering data from multi sheets then performing functions on results

[jrtaylor]

I use tabbed worksheets to create trade histories of multiple trading systems. These histories are then manipulated so that only certain trades are actually executed. For the trades which are not executed, the original data remains in the table, but certain columns to the right of the table will be blank.

A summary sheet includes a table showing all trades from all the tabbed worksheets. I make additional cacluations based on the data in the summary table.

The summary table includes those rows which do not contain executed trades.

I would like to create a macro (or use an array function?) to eliminate the rows where there is no data. HOWEVER I need to make additional (complex) calculations once this new table is created. If there is a way to accomplish this with PTS I haven't figured it out.

Can anyone help? Spreadsheet is attached. Thanks!

[martindwilson]

i just record a macro to cut/paste table to newsheet, auto filter to include 0 only,delete visible rows then cut paste back to original loction

[jrtaylor]

Thank you Martin.

I suppose I should have mentioned that all tables (summary, and the individual tabbed sheets) need to be dynamic.

For example I may want to see what an equity curve looks like if I enter "2" in cell D25 of the summary page, or change cell F32 to 400 rather than 300.

Because I am constantly changing variables such as these, wouldn't it be cumbersome to have to run a macro each time I change a variable? (The sample sheet represents only a small portion of my dataset.)

Is the solution to create a dynamic table with ALL calculations (including running totals and complex SUMIFS forumlas) in the dynamic table?

(If so, can someone please tell me how to insert complex functions in a PT or other filtered table) Thanks.