Sorry if this has been asked, which I'm sure it has.
I am working on a pay stub sheet and would liek to include a YTD field. I want it to get the YTD info from the last version of the pay stub and add the new totals to it.
I have been looking around, but i really don't know excel all to well.
I'm running excell 2007.
Last edited by genesaika; 02-09-2012 at 08:12 PM.
it'd be pretty simple if you knew what data you wanted to sum
=sum(sheet1!A1,A1) would sum A1 from sheet1 (prior week YTD) and A1 from the current sheet (gross pay this week), you just need to enter the name of your sheet and the correct cell references. Or post an example of your workbook
I'm currently not able to post my data, on my cellphone.
So If my YTD. Was on D17 and gross was on D16 the formula would be =sum(sheet1!D17,D16) and that would take the YTD from sheet1 and add the gross from sheet2?
So I tested it and it works fine, but is there any way to make it use the data from the most recent file, without having to type in the file name?
Let's say I have 100 sheets, I'd like it to open sheet100 and use that data automatically, without me typing in the file name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks