Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 01-27-2023, 12:42 PM
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 ArviLaanemets View Post
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.
Same Sheet.
Yes, Defined tables.
Two separate tables: here's my reasoning - Table1 is for a barcode scanner data entry...using a defined table is nice because when you scan the data into column A and then into B, it goes to the next row-column A automatically without keyboard input. I can focus on scanning with an occasional glimpse back at the laptop to make sure nothing was missed.

I used to do this all with one table, as you suggested, by unlocking columns AB then protecting the sheet and unchecking Select Locked Cells to make data entry easier. This worked great for me but I want to share this template with my team.

In the end what I'd like is a way to scan data into the two columns without keyboard input, and be able to copy the massaged data into our database tool. I thought if I could set it up with two Tables I could avoid the need to protect and unprotect the sheet for the most user-friendliness.
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:37 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