Auto populating values from one table to another without que

K

kman

New Member
Joined
Dec 11, 2002
Messages
35
Further detail.

Yes I do want to use this for data entry purposes.

I want the table2 lastnames to always contain the latest values of lname in table1. So as soon as data as new data is inserted into lname table1 it will autopopulate the values into lastnames in table2.

Can you explain how to implement the vlookup in Access if it would be of value for my table?
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
You must log in or register to reply here.

Similar threads

G
  • Question
VBA help - copy cells from specific table to specific table on another sheet.
Replies
0
Views
680
GardianAngelUK
G
T
  • Solved
Using reference data from one table to populate another column/table
Replies
2
Views
168
thirdeye85
T
K
  • Solved
populating a textbox on a userform from selections that are made from a listbox that is one another userform (popup)...
Replies
4
Views
619
kbishop94
K
B
  • Solved
Populating combobox from table based on the header selected in another combobox (some data on different sheets)
Replies
7
Views
557
BWL388
B
copperwasher
  • Question
Automatically populating a table with data from another
Replies
3
Views
593
Micron
M

Forum statistics

Threads
1,221,497
Messages
6,160,152
Members
451,625
Latest member
sukhman

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top