IDs Included in Another Table

L

Legacy 436357

Guest
Hello,

I have Table1 that has the first column of IDs. How can my Table2 include all of those IDs in the first column dynamically?

Thank you
 
Last edited by a moderator:

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Aryatect

Active Member
Joined
Jun 17, 2019
Messages
308
Hi, See if this help:

ABCDEFGH
1IDSome1Some2Some3Some4ID
2A886821812604214A
3B8647477533282658B
4C950054959068621C
5D2540714029665301D
6E9401728439893672E
7F9905182428183054F
8G8149865151097415G
9H
10
11
12
13

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2

Worksheet Formulas
CellFormula
H2=IFERROR(Table1[@ID],"")

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>

here boundaries of Table 1 is till row 9 and Table2 can be more than that, so that when you add entry to Table1 it gets added to Table2.

Please note: Here I am assuming that ID appears only Once in Table1 and you want same in Table2
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,090,077
Messages
5,412,216
Members
403,423
Latest member
fori_gump

This Week's Hot Topics

Top