help on linking different worksheets into one

  • Thread starter Thread starter teyhuiyi
  • Start date Start date
T

teyhuiyi

i need urgent help on the linking of different worksheets into 1..

scenario:

this particular company deals with circuit boards. they will collec
data during inspection in a spreadsheet. and i am using the pivot tabl
to analyse the raw data and display a list of top defects. is there an
way i can compile all the raw data into a excel spreadsheet so that th
pivot table can analyse the data then display it the pivot table an
pivot chart
 
teyhuiyi,
The pivot table a number of ranges, as long as the all have the same heading
and structure.

NickHK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help! Cannot open pivotTable source file.... 2
Multiple Worksheets Protection 1
MS Excel VBA Pivot table link cell fetch records 1
Can I pull 2 different data tables into one pivot table 1
Dynamically generated content 1
How to refresh a pivot table that uses changing source data 1
Update Pivot from datasheet in different folder 1
Creating a Calculated Field in a Pivot Table for same field 3

Back
Top