Forum Discussion
Solved
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.
- 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
6 Replies
- 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
Oh... power query is an add-on. Isn't there something I can do with formulas?
- Using formulas wouldn’t be robust solution for this sort of work, if you cannot install power query then why not use the free RDB Merge addin which do not require any installation, it is an xlam addin file that you load and you don’t need the admin right to instal
It. I have given the link in my earlier comment, there are more detail there on how to use the addin.
If you have any question, feel free to write back here.
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!
