software

I want to create these fields:
coloumn a: a drop down list of names
column b: drop down list of dates
column c: drop down list of some numbers and alphabets

I want to corelate all these three columns for the item selected.
eg: if i select name quot;johnquot; from column a and quot;1/1/6quot; from column b and
select quot;4quot; from coumn c then i need a report generated which will mention
quot;johnquot; on quot;1/1/6quot; had quot;4quot; units and quot;johnquot; from quot;1/1/6quot; to quot;31/1/6quot; had quot;??
total unitsquot;

Can some one help create the same.

Hi Dr. Akash Rajpal,

See my Excel database tutorial at www.edferrero.com/DataTutor01.aspx

Ed Ferrero
Microsoft Excel MVP
www.edferrero.com

gt;I want to create these fields:
gt; coloumn a: a drop down list of names
gt; column b: drop down list of dates
gt; column c: drop down list of some numbers and alphabets
gt;
gt; I want to corelate all these three columns for the item selected.
gt; eg: if i select name quot;johnquot; from column a and quot;1/1/6quot; from column b and
gt; select quot;4quot; from coumn c then i need a report generated which will mention
gt; quot;johnquot; on quot;1/1/6quot; had quot;4quot; units and quot;johnquot; from quot;1/1/6quot; to quot;31/1/6quot; had
gt; quot;??
gt; total unitsquot;
gt;
gt; Can some one help create the same.