Use hyperlink to transfer data from a specific row to another sheet.

How can I click on a hyperlink to transfer the data on that specific row to an "Overtime template" on another sheet. Is there also a way that Excel can recognize and automatically change the date in "Date Finished" caption when the employee works past 2400 hrs? I previously requested help from Ozgrid but did not receive any suggestions. That link is http://www.ozgrid.com/forum/showthread.php?t=178890. I am new to forums and VBA. Thank you, Chris.

Do you mean to create a new "overtime claim" sheet for each day/employee with overtime?

To get the date finished if the employee works past midnight, I would try this formula:

=IF('Hours Work'!C2<'Hours Work'!B2,'Hours Work'!A2+1,'Hours Work'!A2)

I want to be able to use that same "ovetime claim" sheet for each day. Just have the overtime info (date started, time started, date ended, time ended, total time worked, and total overtime) change depending on the hyperlink, if that is possible. All employees will have a copy of the program so they can enter their pedigree which will remain constant. Thank you so much for the code you gave me.

I would set up a date selecter with a drop down box, then use advanced filter to copy the selected date to another area. Then have the formulas on the claim reference the advanced filter copy location. You could hide the copy location so no one sees it. You can then add a button to attach a macro that when selected will apply the filter based on the date selected and take you to the claim. I've attached your spreadsheet that I did this, I left the copy to location visible but you could hide it. It is not exactly what you were looking for, but does what I think you want it to - select a date and go to the form with the info all filled in.

Please Login or Register  to view this content.

Thank you very much for your help and time Powdow.