Hello
i have this xls file
i have a sprite sheet for each salesman
each sales man has customers and asset number and month days (31)
i want a sheet at the front gives me 4 fields
1- ( i choose a salesman ) scroll down options
2- i choose a date (( only days no months or years )
3 i put an asset number
4 i put the total sales for that day
bottom ( enter/) to make the data entry to the right cell in the right sheet