Copy Entire Rows to another sheet

Hi Gaz,

SG wrote:

There are likely to be more efficient approaches keeping your like data all in one place. With your data all in one place you have a lot of tools that can be used: SUMIFS, COUNTIFS, AVERAGEIFS, MAX, MIN, etc. to extract summary statistics, filters that can be applied as Ian as suggested, and also the Categories feature (see Organize menu) that in a way combines filtering, grouping, and summary statistics, all without writing a formula.

Here is a simple example using one table with a Filter. SUM will sum all rows, whether visible or hidden with a filter. However, we can use SUMIF for rows that contain "Show" in the Show? column.

Formula in Footer Cell B10 =SUMIF(C,"=Show",B)

Or we can use other functions in a separate summary table.

Better, take a look at Categories as suggested by SG.

Regards,

Ian.

Hi Gaz,

How about a Filter on the main input table? Then you need only one table.

Then apply a Filter to Table 1

Please reply with questions.

Regards,

Ian.

Gaz1892a wrote:

so, is it actually possible to do my original question?

It is possible with extra columns and rather complicated, fiddly formulas. Could you give us a further screenshot of how your work has evolved to this point, and what you are trying to do?

There are likely to be more efficient approaches keeping your like data all in one place. With your data all in one place you have a lot of tools that can be used: SUMIFS, COUNTIFS, AVERAGEIFS, MAX, MIN, etc. to extract summary statistics, filters that can be applied as Ian as suggested, and also the Categories feature (see Organize menu) that in a way combines filtering, grouping, and summary statistics, all without writing a formula.

SG