Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

So what I have so far is a spreadsheet that will auto time stamp column N when my technicians enter their initials into column M.

Now the 2nd thing I would like the spreadsheet to do is.

When I enter the hours (example: 1.8) into column E "HRS." And have the spreadsheet put the HRS. into the correct Technicians column. Based on the initials entered in column M "Tech Up".

Example: if E4=1.8 it would put 1.8 into G4 because M4=AB
Example: if E6=3.2 it would put 3.2 into J6 because M6=JW

I have a screenshot could paste, but I'm a new user to the site. Thanks for the help.

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

Something like this? The ranges are different here but the logic is the same - each cell in your range gets a formula like this (this is cell B2 in the screenshot):

=IF($E2=B$1,$A2,"")

Which checks to see if the value in the Name column is equal to the column heading of the current cell; if so, it adds the value you put in the HRS column, and if not, it stays blank.

enter image description here

share|improve this answer
    
Let me try this. –  myanda Oct 10 '12 at 22:58
    
WOOT!!! That is exactly what i was looking for!!! Thx –  myanda Oct 10 '12 at 23:11
    
@myanda No prob, happy it helps! –  RocketDonkey Oct 10 '12 at 23:22
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.