extracting data

  • Thread starter Thread starter manish
  • Start date Start date
M

manish

i have a worksheet which has daily entries for say about 7
companies. there can be say 7 entries for a particular
company on one day and on the other there may be only one
entry. Now at the end of the month there may be say 150
entries of one company1, 400 entries of company 2 and 300
entries of company3 and so on.
Now, what i want is to extract all the data of company1 on
a separate sheet, company2 on a separate sheet and so on..
in such a way that if i add a few more entries in the
daily entry sheet the entries should be automatically
updated in the respective companies individual sheet.
the solution would be very helpful
 
Manish,

Take a look at using Pivot Tables. You will be able to do everything you
describe by using multiple Pivot tables and showing only the data for one
company in each pivot table. You could also extract the data for each
company by 'drilling down' - double clicking on the company name once the
Pivot table is set up, but the drill down is static and not dynamic. When
you add new data, you should do it in such a way that it is added within the
range referenced by the pivot tables.

HTH,
Bernie
MS Excel MVP
 
Back
Top