hi everybody,
I am trying to create customised dashboard with excel sheet. i tried with lookup, pivot and drop down list but unable to get desired output. can anybody advised me how to create this
attached herewith sample data and output I am looking. I need .................
1. "PRODUCT ID" OR "CENTRE" COLUMN AS INPUT CELL IF I ENTER VALUE IN ONE OF THE CELLS ALL OTHER DETAILS SHOULD APPEAR
2. IF IN "NATURE" ANY PRODUCT ID SHOWS HAS "SURRENDER" THEN TYPE COLUMN SHD BE "SURRENDER" OR "LIVE"
hope I could explain the query properly still if it needs further clarification pl do mention...
thkx - waiting for your help
I am trying to create customised dashboard with excel sheet. i tried with lookup, pivot and drop down list but unable to get desired output. can anybody advised me how to create this
attached herewith sample data and output I am looking. I need .................
1. "PRODUCT ID" OR "CENTRE" COLUMN AS INPUT CELL IF I ENTER VALUE IN ONE OF THE CELLS ALL OTHER DETAILS SHOULD APPEAR
2. IF IN "NATURE" ANY PRODUCT ID SHOWS HAS "SURRENDER" THEN TYPE COLUMN SHD BE "SURRENDER" OR "LIVE"
hope I could explain the query properly still if it needs further clarification pl do mention...
thkx - waiting for your help