I've attached a very trimmed-down example of a large workbook. In order to get the file size small enough to upload to the forum, I eliminated much data and many formulas, leaving enough values and tables to illustrate my question.
In the "real" workbook there are 10+ worksheets, each with large tables, some having as many as 3,000 rows. Each row in these tables contains many formulas. The rows are sorted by date, so I cannot re-sort them, as it would corrupt some of the forumulas in the rows. (for example, some values in row 3 are dependent on values in rows 1 through 50)
I want to reassemble the data from these worksheets into a summary table (in worksheet titled "summary." The specified rows I want to copy from each worksheet can be identified by looking at the values in column AK. If that value is greater than 0, I want to include data from that row in the summary worksheet.
Once the new summary table is created I intend on performing additional analysis of the data, including perhaps inclusion of new formula columns. (I mention this because I haven't figured out how create new formulas after having created pivot tables or arrays).
Thanks.
Bookmarks