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
Okay, I'll look into the add-on you linked in your first post. I'm just looking for an easier way to do this task rather than doing it manually. Thanks again!
The add-In is the best one to combine multiple workbooks into single workbook. you can customize by defining name, or specific range etc. it is very easy to use and it is not going to be manual. the add-in does it automatically.
I can write VBA code for you to do the same thing, but it wouldn't be as effective and user friendly as the add-in, so when there is already a free add-in available, why re-invent the wheel.
Please post back, if you have difficulties using the add-in.
I can write VBA code for you to do the same thing, but it wouldn't be as effective and user friendly as the add-in, so when there is already a free add-in available, why re-invent the wheel.
Please post back, if you have difficulties using the add-in.