If Sums from two different sheets or vlookup or???

[nicholsnj]

I am trying to create an overtime spreadsheet to keep track if someone has been asked to work overtime. When they are asked I need to show if they accepted the hours or refused. But either way the total of hours for a particular person needs to increase. I have a starting point on the hours.

If cell c3 from sheet 1 = cell a2 in current sheet then add cell b6 and b7 from sheet 1 to cell c3 of existing sheet

I've attached my file.

Sheet 1 is a form that will be filled out with the persons name and hours worked or refused. Sheet 2 and onward have the persons name and total hours accumulated for the year.

So I need the hours to increase on that person in the other sheet when they submit the form with a button after filling in the information.

If that doesn't make sense let me know.

[rcm]

Please Login or Register  to view this content.

will do the job. (You would have to copy the formula to each an every cell in all the sheets) But I suppose you need a more automated solution via VBA? I will gladly code it for you.