Forum Discussion
Pulling Scattered Data from Workbook into Different Workbook
mathetes Thank you for your help !!!!
Please see below template of the File I'm working with. Basically, I want to create a separate Excel Book which will list the Work Order numbers along with the QTY ( Photo below of the list I'm hoping to get in the New Book ).
Two Things to Note:
1. Sometimes the Work Order Number repeats ( I would like the New Book to give me the total QTY. but if it's not possible, I don't mind if it has multiple records for the same Work Order ).
2. There are multiple sheets in the Original Workbook which all look the same - I would like to pull all the Work Orders from all Sheets into 1 Sheet on the New Book.
Thank you again for your help 🙂
Since this is a template workbook that you've given us images of, let me ask again if you could post the actual workbook. Images are better than words, but they're still images only. Working with the actual workbook gives us the opportunity to not only suggest a formula or two, but also to test it. And if your actual workbook could include some representative data, all the better, so that we don't have to imagine that as well.
Post this workbook by attaching to your reply. If you aren't able to do that, put it on OneDrive or GoogleDrive and paste a link here that grants access.