Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connect different worksheets
Hi all,
I would like to do the following: I have two worksheets. In one of the worksheets I have a list of items, lets say ID VEH. COL. PRIZE. 1 CAR BLUE 900 2 CAR RED 1800 3 BIKE RED 300 i.e. four columns, one for identification, one for vehicle type, one for color and one for prize. The 'vehicle type' and 'color' are ´pre-defined scroll bar lists. Now, what I want to do is to have anothe work sheet where all blue vehicles appear (i.e. the full row as in ID, VEH., COL, PRIZE). I.e the list in the 'blue work sheet' would be 1 CAR BLUE 900 but if I change the RED car to BLUE the list would be 1 CAR BLUE 900 2 CAR BLUE 1800 Does anyone know how to achieve this? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connect different worksheets
This will do it for you:
http://www.rondebruin.nl/copy5_1.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Marten" wrote: Hi all, I would like to do the following: I have two worksheets. In one of the worksheets I have a list of items, lets say ID VEH. COL. PRIZE. 1 CAR BLUE 900 2 CAR RED 1800 3 BIKE RED 300 i.e. four columns, one for identification, one for vehicle type, one for color and one for prize. The 'vehicle type' and 'color' are ´pre-defined scroll bar lists. Now, what I want to do is to have anothe work sheet where all blue vehicles appear (i.e. the full row as in ID, VEH., COL, PRIZE). I.e the list in the 'blue work sheet' would be 1 CAR BLUE 900 but if I change the RED car to BLUE the list would be 1 CAR BLUE 900 2 CAR BLUE 1800 Does anyone know how to achieve this? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Connect different worksheets
Hi,
Create a pivot table with ID and vehicle number in the row area, colour in the page field area and prize in the data area. In the pivot, get rid of the subtotal rows. Now while your cursor is in any cell in the pivot table click on the Show pages in the pivot table drop down button (in the pivot table toolbar). Click on OK. This will create two separate tabs - one for blue cars and the other for red cars. If you change the colour in the source data, you just need to refresh any one of the sheets - blue or red and all pivots would update. Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Marten" wrote in message ... Hi all, I would like to do the following: I have two worksheets. In one of the worksheets I have a list of items, lets say ID VEH. COL. PRIZE. 1 CAR BLUE 900 2 CAR RED 1800 3 BIKE RED 300 i.e. four columns, one for identification, one for vehicle type, one for color and one for prize. The 'vehicle type' and 'color' are ´pre-defined scroll bar lists. Now, what I want to do is to have anothe work sheet where all blue vehicles appear (i.e. the full row as in ID, VEH., COL, PRIZE). I.e the list in the 'blue work sheet' would be 1 CAR BLUE 900 but if I change the RED car to BLUE the list would be 1 CAR BLUE 900 2 CAR BLUE 1800 Does anyone know how to achieve this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I connect 2 worksheets with a formula? | Excel Worksheet Functions | |||
How do you connect worksheets,input data in one place&it shows on | Excel Worksheet Functions | |||
How do I connect two worksheets together? | Excel Discussion (Misc queries) | |||
Formula to connect cells in different worksheets? | New Users to Excel | |||
Help! I need to create worksheets to connect? | Excel Worksheet Functions |