←Back to all posts
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Easy way to extract info from multiple sheets into one sheet?

I have 60 sheets with identical layouts. I'm hoping to extract information in each sheet and spit out into a table on a separate sheet. I would want column 1 to have every D3 value , and the corresponding H7:H100, as shown in the 2 screenshots.

Please let me know if this is doable

Thanks!

examples

submitted by /u/jimmyjamcake
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→