Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 01-27-2023, 01:18 AM
ArviLaanemets ArviLaanemets is offline Auto-populating table based on another table? Windows 8 Auto-populating table based on another table? Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-Entering Values into a Column in a Table based on Value in Adjacent Column nytvsh Excel 2 12-06-2021 12:33 AM
Auto-populating table based on another table? Populating fields from a table serrix Word 3 02-24-2016 12:19 AM
Scanning Barcodes Populating Table with Info Sueade Excel 0 11-10-2015 05:51 PM
Populating a table cell wit document properties milena Word VBA 2 04-15-2015 07:28 AM
Auto-populating table based on another table? Update Word table based on another table input mpdsal Word VBA 10 10-29-2012 07:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft