![]() |
#7
|
|||
|
|||
![]() Quote:
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. |
|
![]() |
||||
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 |
![]() |
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 |
![]() |
mpdsal | Word VBA | 10 | 10-29-2012 07:40 AM |