I have a payroll workbook. you simply enter in hours worked and hourly pay rate on tab 1 and it figures social sec. medicare and federal income tax deductions and figures a paystub on a separate tab. i'm trying to keep a YTD total on the paystub as well as a YTD total tab for each employee to see past pay totals, etc.
how can i figure a formula that will see the date on the paystub in tab 4 and pull the pay information from that date to a YTD totals tab without having to manually enter the info each week on pay day.

THANKS!!