•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!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#google sheets
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#extract
#D3 value
#excel
#multiple sheets
#information
#H7:H100
#identical layouts
#data extraction
#table
#separate sheet
#column 1
#sheets consolidation
#screenshot
#value retrieval