Auto-populating table based on another table?

		Microsoft Office Forums > Microsoft Excel > Excel
Auto-populating table based on another table?

FAQ

Thread Tools

Display Modes

01-27-2023, 08:39 AM

p45cal

Windows 10 Auto-populating table based on another table?

Office 2019

Expert

Join Date: Apr 2014

Posts: 962

In that case, the likes of:
=HSTACK(Table1[Hdr1],Table1[Hdr2]/2,Table1[Hdr2]^2)
at cell D2. The result is NOT a proper Excel Table, and it won't work if you try to make it a table.

2023-01-27_153524.png

Column E is half, and column F is squared.

Attached Files

msofficeforums50314.xlsx (10.7 KB, 8 views)

« Previous Thread | Next Thread »

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
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
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 02:51 AM.