Looking for some help with a complicated formula to corrilate with 3 sheets. I would have to email someone the file to see what I am needing. I've been trying to figure this out for some time. Anyone can help please send me your email address or a way I can send you the Excel file. Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Complicated Formulas across 3 Sheets
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,140
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
We have tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.
If that is not sufficient, then you can upload your file to a file sharing site, like "DropBox", and provide a link here.
Just note that some people cannot (or will not) download files from internet or email for security reasons.
We have tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.
If that is not sufficient, then you can upload your file to a file sharing site, like "DropBox", and provide a link here.
Just note that some people cannot (or will not) download files from internet or email for security reasons.
Upvote
0
https://www.dropbox.com/s/vjgqtmt9aijs26j/PCM COST TRACKING-LUMBERTON 18-1224001B MOCKUP.xlsx?dl=0
Please see the attached Link, We have been asked to change to a different spread sheet for job cost tracking. I rather use my more accurate spreadsheet but, this is what they want...
So what I am trying to achieve is:
I enter Payroll daily into the two sheets "Mechanical Payroll & Civil Payroll". These entries are Daily man hours and Per Diem. If you click on the Cost tracking sheet cells that I have numerical values in you will see my formulas. "=count(), =sum() and =sum(x + x)".
I want to be able to enter the formulas across One date one the Cost tracking sheet and Drag it down to correlate the same formula but corresponding with the dates. I know this will be odd due to Cost tracking sheet dates are in order every line down and Payroll sheets skip rows for the information.
At the end of every week I highlight the payroll and send it as PDF to payroll department. This will help to not have to inter the same information several times so as I update Payroll every day it auto fills in cost tracking with payroll and per diem. Hope I am explaining this correctly. As of now, I have to enter the formula for every date across the cost tracking sheet jumping from sheet to sheet to highlight cells...
Is this achievable?
Please see the attached Link, We have been asked to change to a different spread sheet for job cost tracking. I rather use my more accurate spreadsheet but, this is what they want...
So what I am trying to achieve is:
I enter Payroll daily into the two sheets "Mechanical Payroll & Civil Payroll". These entries are Daily man hours and Per Diem. If you click on the Cost tracking sheet cells that I have numerical values in you will see my formulas. "=count(), =sum() and =sum(x + x)".
I want to be able to enter the formulas across One date one the Cost tracking sheet and Drag it down to correlate the same formula but corresponding with the dates. I know this will be odd due to Cost tracking sheet dates are in order every line down and Payroll sheets skip rows for the information.
At the end of every week I highlight the payroll and send it as PDF to payroll department. This will help to not have to inter the same information several times so as I update Payroll every day it auto fills in cost tracking with payroll and per diem. Hope I am explaining this correctly. As of now, I have to enter the formula for every date across the cost tracking sheet jumping from sheet to sheet to highlight cells...
Is this achievable?
Upvote
0
