I've got a workbook with multiple sheets that I would like to chart specific data from.
Users will be able to add sheets for each new batch of parts (so the charting dataset is dynamically changing). I've discovered that I cannot chart from multiple sheets, so I would like to compile all of the data into one spreadsheet. Here's what's going on . . .
The Summary spreadsheet would look like this:
ColumnA
Batch #
123
124
125
ColumnB
Part Number
456a
457a
456a
ColumnC
Yield %
76.6%
97.6%
86.6%
the data in column A always comes from cell B14, the data in column B always comes from cell B15 and the data into column C always comes from cell C8. Like I said, users can add spreadsheets as needed, but the data will need to be automatically loaded into the summary spreadsheet for charting.
fortunately, I have the charts built and other VB objects, I just haven't been able to figure out the data summary process.
Thanks!