hey guys
i know this has been covered before but im stuggling to work out how to get it to work for my circumstance
sheet1
a company
b service
c day
d time frame
e unit cost
f time spent
g total cost
im trying to work it out so that when you choose a company it lists the services of that company
then based on services you get a drop down for day, and so on till it auto fills unit cost
if anyone can give me some advice on this it would be great i have a sample im already working on but cant seem to get it quite right yet
edit: have done some more work on sheet to reflect 2nd company in first sheet and to sho difference in times of day for different companys