I hope someone can help me with this as I can't really find any info that works for my needs..
I have a simple spread sheet for tracking my hours worked and my pay, depending one what job function I perform that day. Tech= $10 , Video= $20s
I've made a dropdown list for my two different job functions in cell "H5". I have my hours worked in cell "G5" and I want my wage earned to appear in cell "I5". On my second sheet "Data" I have my to jobs listed in cells "A1, A2" and their corresponding wages in cells "B1,B2". I want to select my job from the dropdown list on the first sheet and have it automatically multiply my hours from Cell "G5" with the associated wage from the Data sheet. If someone could help that would be FANTASTIC.. I tried to post a picture but my status onsite isn't high enough yet..
Thanks so much
Aucun commentaire:
Enregistrer un commentaire