Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Finding Data from Multiple sheets
Hi
I have a spreadsheet that contains the following: Rows = Products Columns = Months Data = how many products sold in each month This data is replicated on numerous sheets, each sheet is an individual client. I need to look at the products sold over each month, for each customer and identify - who sold the most per month? Ideally creating a list of the top ten customers. I have tried copy and pasting data from each sheet into one and used this as a database to create a pivot table, but the whole process of copying and pasting each clients data takes so long to do. Any advice would be great |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Finding Data from Multiple sheets
With a Totals row on each sheet you could either set up links on the
Compilation sheet, one row for each sheet. Then, as the sheets are updated, your compilation sheet will be updated automatically. You can then have autofilters set up to do your identifying the top ten etc. Once you have set up links to the first sheet, copy and paste that one down the rows for as many sheets as are populated. Highlight each following row and do a Find/Replace on each row to assign the links. This operation will take a little time but will save a lot of time afterward. -- Best wishes, Jim "trainerab" wrote: Hi I have a spreadsheet that contains the following: Rows = Products Columns = Months Data = how many products sold in each month This data is replicated on numerous sheets, each sheet is an individual client. I need to look at the products sold over each month, for each customer and identify - who sold the most per month? Ideally creating a list of the top ten customers. I have tried copy and pasting data from each sheet into one and used this as a database to create a pivot table, but the whole process of copying and pasting each clients data takes so long to do. Any advice would be great |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
Finding the average across multiple sheets | Excel Worksheet Functions | |||
finding data with multiple criteria | Excel Discussion (Misc queries) | |||
Finding common Data in multiple worksheets | Excel Discussion (Misc queries) | |||
Finding Data in multiple worksheets | Excel Discussion (Misc queries) |