HAI ,I AM NEWBIE FOR EXCEL,
I HAVE SOME QUESTION ASK IS
I DO A 2 SHEET IN EXCEL ,1 IS LAYOUT AND 1 IS DATABASE.
WHEN IN LAYOUT SHEET I HAVE CREATE DROPDOWN LIST ,AND LINK TO DATABASE SHEET.
WHEN CHOOSE THE D.DOWN LIST IT WILL NOT SHOW OUT ALL THE DATA FOR THE PROD THAT I CHOOSE FROM DROP DOWN LIST.
I HAVE SOME QUESTION ASK IS
I DO A 2 SHEET IN EXCEL ,1 IS LAYOUT AND 1 IS DATABASE.
WHEN IN LAYOUT SHEET I HAVE CREATE DROPDOWN LIST ,AND LINK TO DATABASE SHEET.
WHEN CHOOSE THE D.DOWN LIST IT WILL NOT SHOW OUT ALL THE DATA FOR THE PROD THAT I CHOOSE FROM DROP DOWN LIST.