passing values to other sheets

  • Thread starter Thread starter kaja48380
  • Start date Start date
K

kaja48380

hi i am having the columns in the sheet1
date no company amount
01/01/01 1 a 120
01/02/01 2 a 240
01/03/01 3 b 250

in the sheet2 i like to have the values of the company a with the
following columns date,no,amount
 
You would need code to bring across just the rows containing Company a, but
you can do a few things to show just Company a results

1) Copy the data to Sheet 2 and filter it (Data>Filter>Auto Filter)
2) Build a pivot table on sheet 2 from the data on sheet 1 and use Company
as a page/report field
3) Use the subtotal functionality (Data>Subtotals...) if you want to show
the data for the companies, with a total amount at the bottom. This also
'groups' the data

Let us know if this works for you, or if you want the code option

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk
 
Back
Top