1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Pull only specific rows and columns from a table

Our take

If you're navigating the complexities of tables and need to extract specific data without tedious copying or re-typing, you're not alone. Imagine being able to pull just the relevant intersections from your reference chart—like columns A, C, and F intersecting with rows 2, 6, 7, and 10—effortlessly. With the right techniques, you can streamline your data management for your game, revealing how buildings like the Harbor, Dock, and Lighthouse impact point calculations.

I want to copy certain columns from a table, but only the cells where they cross specific rows. For example, I want to pull columns A,C,F but only where they intersect with rows 2,6,7,and 10. So the new table would have A2,A6,A7,A10,C2,C6, ect. Is there a way to do this without hand-copying or re-typing? I haven't worked much with tables before.

This is for a reference chart I made myself for a game where you place buildings and get (or lose) points based on which buildings are nearby. The rows and columns have the same list of headers: columns are what I want to place, and each row shows how many points each existing building would give. I want to make smaller tables with a few buildings and how they affect each other, such as Harbor, Dock, Lighthouse, and Fisher which all go in the same areas. So I would want to pull just the spots where the columns and rows for those 4 intersect.

submitted by /u/Oday-Dolphin
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with