How to generate in Excel a pay stub with a "Year to Date" column?
February 17, 2006 10:23 AM Subscribe
I'm using Excel to create a weekly pay stub for a nanny, but I haven't figured out how to automatically include the previous week's data to create a "Year to Date" column for wages and taxes.
posted by ShooBoo to computers & internet (6 answers total)
I'm using an Excel spreadsheet to create a pay stub for our nanny. On
the pay stub, from her hours her wages and taxes are calculated, and I
also have a "Year to Date" (YTD) column for the totals of wages and taxes
over the year.
Right now, in order to generate a new pay stub for each week, I create
a copy of blank pay stub template to a new Excel file, and copy the previous week's YTD
field values into a "Previous YTD" column, from which the current week's YTD
data is calculated.
I want to avoid having to manually do the copy of "Year to Date"
values from the previous week's pay stub, to the current week's
pay stub. Ideally, I'd like to just enter the week's date and hours, and a
pay stub will be generated including the YTD column. How can this be
done in Excel?
I thought of instead of using a new Excel file for each week's
pay stub, a new sheet for each week can be added to a single Excel file. But I didn't find
anyway to express a formula in Excel that says "Take the previous
sheet's value and put it here". It seems that formulas with sheets can
only include an absolute sheet number, and not a relative one.
Any ideas on how to do this?