Forum Discussion
Extract data from multiple sheet to new sheet in same workbook
I have a workbook with 6 sheets Master Tank List Less than 3000 WC 3000 WC 3200 WC 3400 WC 3700–5000 WC I need to pull data from the 5 WC sheets (excluding the Master Tank List) into a new she...
can you attach a sample (with no private or confidential info) or make it available in a web sharing site like sharepoint, onedrive, google drive.
Since we don't know how the data is arraged in those sheets or how the sheets are arranged the following may or may not work:
=VSTACK('<3000 WC:3700-5000 WC'!B2:G2)
or maybe
=VSTACK('Less than 3000 WC:3700-5000 WC'!B2:G2)
not sure how your sheet is actually named and you need to replabe B2:G2 with the actual location of the data on those sheets
I need to pull data from main Master Tank list, so that data in Summary Excel sheet in same workbook can be auto pulled all time new info added to main sheet for -
Diff tank types (column A)
Less than 3000 WC
3000 WC
3200 WC
3400 WC
3700–5000 WC
In columns B should calculate Quantity for each type of tanks from Column A (from main Excel sheet) and columns C D E F G in Summary sheet should pull data from MasterTank list sheet columns - F H I K L, also column K should calculate value based on Tank size Quantities $1000 for Less than 3000 WC and $1500 for rest all Tanks types.(if Less than 3000 WC tanks are 20 types so K column value for this tank type should be $30000 and so on for rest columns.)
