Hello,
I am seeking assistance on how to link certain data from a master tab to various sub tabs.
The master tab is below. It has several columns, including ID Number, DATE, NAME, AGE, LOCATION, and FRUIT.
\1
On a separate tab, I would like to enter the ID Number in the red cell, and have the data in the corresponding rows from the master tab with the same ID number automatically populate (but only DATE, NAME, AGE, and LOCATION, not FRUIT.
\1
For example, if I entered in "17" in the red cell in the separate tab, the data in the DATE, NAME, AGE, and LOCATION columns from the master tab only with "17" in the ID number column would then automatically populate on the separate tab.
Is this possible?
Bookmarks