Forum Discussion
Viewing data rows from another worksheet in a portal
First off, I'm a novice with Excel. Learning by exploring. I have a worksheet (#1) with 14K+ rows of data (30+ columns). One of the columns on sheet#1 holds a unique ID number for each row. On another sheet (#2) I have 72K+ rows (20+ columns) of data where multiple rows have the same ID# on sheet#1 (where there is only one unique ID field for each row). What I'm trying to do is to be able to view the set of data rows from sheet#2 onto sheet#1 when I click into a certain ID# on sheet#1. Then when I click an ID# of another row, the related data set updates with the rows related from sheet#2. Does this make sense? Any help will be appreciated. In the meantime, I'll keep experimenting. Thanks!
Here are some screenshots:
1 Reply
In the absence of a link to your actual workbook, I'm just going to point you in the direction of the function that I/m pretty sure will do what you want, leaving you to figure out more specifically the "how to"
That function is the FILTER function, and it will require Excel 2021 or newer. This link takes you to a website that describes how to use it.
And this video is also very instructive.
I'd be happy (and I'm sure others would too) to help further. You can help us help you by posting a copy of the actual workbook (or a reasonable facsimile)--not an image-- on OneDrive or GoogleDrive, with a link pasted here that grants access to it.
