Forum Discussion
Posting certain rows from multiple tabs to a summary tab in excel
Not sure how to go about doing this so figured I would come here. I have a spreadsheet with tabs for each of our companies jobs. Lets say there are 25 jobs with 1000 part numbers for each job per t...
It seems you need a pivot table (insert - pivot table); highlight all the cells you want to consider and try with "suggested pivot table"; then you'll see if it's what you need or not. It's also possible to insert datas from more than 1 table (as I see, from different tabs of the same worksheet).