gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,342
- Office Version
- 365
- Platform
- Windows
Is there a way to have one column in a table equal a column in another table?
The first table source can vary in number of rows depending on what the user enters.
The first table, where the data is coming from is titled "TableItemID" its on a tab name ItemID and the Field I want to use is called [ItemID]
The second table where I want to always have matching data is titled TableItemIDCP and the field in that one is also call [ItemID]
I assume VBA.
Thanks
The first table source can vary in number of rows depending on what the user enters.
The first table, where the data is coming from is titled "TableItemID" its on a tab name ItemID and the Field I want to use is called [ItemID]
The second table where I want to always have matching data is titled TableItemIDCP and the field in that one is also call [ItemID]
I assume VBA.
Thanks