Viewing data rows from another worksheet in a portal

Tracy C

New Member
Joined
Mar 6, 2024
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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:
 

Attachments

  • 1.jpg
    1.jpg
    240.8 KB · Views: 8

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Could you share your actual file via Google Drive, Dropbox or similar file sharing platform? Please make sure you make it available to anyone with the link.
 
Upvote 0

Forum statistics

Threads
1,223,885
Messages
6,175,178
Members
452,615
Latest member
bogeys2birdies

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