Forum Discussion
Paula DeRoo
Mar 08, 2018Copper Contributor
Pull values from other sheets to a summary sheet in workbook
Hi, I have an Excel 2010 workbook full of sheets that I want to pull from certain cells from each sheet and then insert them into a "summary" sheet. Not sure if there's a way to do this or not.
- Mar 08, 2018The best easy way will be either to use power query or the free addin from here https://www.rondebruin.nl/win/addins/rdbmerge.htm
Jamil
Mar 08, 2018Bronze Contributor
The best easy way will be either to use power query or the free addin from here https://www.rondebruin.nl/win/addins/rdbmerge.htm
Paula DeRoo
Mar 08, 2018Copper Contributor
It'll have to be a power query. IT frowns upon us installing anything on our computers! I'll look into the power query thing - thanks!