Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help -- URGENT -- need to resolve the issue before submittingmy project
Dear All,
I have two excel sheets. on sheet 1 i have the following data: DB_Code DB_Type DB_DISC 111 1 234 222 2 232 333 3 3343 on sheet 2 I have the following data: DB_Code XXX YYY 111 34 21 222 23 234 333 43 5435 Now, what i want to be able to do is the following, when i filter sheet 1 by lets say column DB_Type, I get a selection of DB_Codes. (Assuming i filter DB_Type by 1, I will get the row with DB_Code 111). Now i want that in sheet 2 where again i have DB_Code, only row with Db_code 111, should be selected..as if it was filtered and the outcome of the filter in sheet 1 is actually reflected in sheet 2.. THank you so much for your help. Regards, Sunny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
not sure how to resolve this issue on my computer | Excel Discussion (Misc queries) | |||
Resolve Circular Ref Issue | Excel Worksheet Functions | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
Time calculation problem (URGENTProject due) | Excel Discussion (Misc queries) |