Good afternoon all.
I need some help on attached.
I have "Sheet1" where based on Project selected from Drop down ( cell B6) i am getting values for Cost Account #1 & #2 and Month ( Actual ). This data is pulled out from sheet called "All Transaction".
I am trying to get details ( to see all lines from " All Transaction" which are included in this amount) for example Cost Account #2 by clicking on amount which is 10AED in this case. This amount is changeable due to several projects which i have ( in drop down menu).
Data for the full year are included there.
I have attached sheet with some data, considering should be easier to understand.
Thank you
Bookmarks