View Single Post
 
Old 01-27-2023, 01:18 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Do you have the Table2 on separate sheet, or on same sheet with Table1? I hope you are using Defined Tables - when formula is same for whole Defined Table column, it auto-populates whenever you add new rows.

When on same sheet, and you want to report all records of your data, then there is no reason to have 2 separate Tables. Simply add those calculated columns into same Table. In case you want to print out 1st column values and calculated columns, add a calculated column which duplicates column A too. Like
Column A;
Column B;
Column C = [@[Column A]];
Column D = Formula1;
Column E = Formula2

To get the printout from columns C:E only:
Define a dynamic Named Range, which includes those columns;
Set the Print Area for sheet equal to this Named Range.

In case you want to report some subset of records, then you need a separate Report sheet, where user can determine filter conditions, and a Report Table reads matched info from Data Entry sheet. Report Table must have enough records to return any data, and can have any number of empty rows at bottom. For printout, you define Named range which includes all non-empty records in Report Table (probably you need a calculated column there which registers records with any data), and you set Print Area for Report sheet equal to this Named Range.
Reply With Quote