Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-27-2023, 01:55 PM
p45cal's Avatar
p45cal p45cal is offline Auto-populating table based on another table? Windows 10 Auto-populating table based on another table? Office 2019
Expert
 
Join Date: Apr 2014
Posts: 962
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by 0rion View Post
Amazing tool, but our Enterprise version of O365 is still 2108 and it looks like hstack came out with v2203. Thanks, this may do it.
While awaiting HSTACK, take the 3 components and put them in adjacent cells:
=Table1[Hdr1]


=Table1[Hdr2]/2
=Table1[Hdr2]^2
Attached Files
File Type: xlsx msofficeforums50314.xlsx (10.7 KB, 6 views)
Reply With Quote
  #2  
Old 02-03-2023, 09:24 AM
0rion 0rion is offline Auto-populating table based on another table? Windows 10 Auto-populating table based on another table? Office 2021
Novice
Auto-populating table based on another table?
 
Join Date: Jan 2019
Posts: 11
0rion is on a distinguished road
Default

Quote:
Originally Posted by p45cal View Post
While awaiting HSTACK, take the 3 components and put them in adjacent cells:
=Table1[Hdr1]
=Table1[Hdr2]/2
=Table1[Hdr2]^2
Thanks Folks, this seems to do the trick. Much appreciated!
Reply With Quote
Reply



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 02:52 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