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 |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com