I have data from approximately 8 to 10 worksheets usually in the same
workbook . am trying to consolidate the data using a pivot table , firstly
have been past linking the data on one sheet then using a pivot , problem is
that there is to much data for the pivot table to manage and it is easy to
delete a paste link loosing important data. is it possible to consolidate
data direct from each sheet to the same pivot table?
--
thank you for your help !