I need to take the pivot table information on Sheet 3 and sum it on Sheet 2 to the corresponding week & column ie: Unplanned, Planned, Scheduled, etc. I need to report it by week and want to know if there is a formula I can use to do this instead of looking at Sheet 3 and manually entering the values onto sheet 2. I filled the cell values in Sheet2 to show what I want to do.
Would you consider using the data from sheet 1 to get the results. If so you could use the following formula in cell D2 (sheet2) and down:Formula:
Please Login or Register to view this content.
To apply the formula to column F change the header to read 'Planned Maintenance',
1) Select cell D2 and press the Ctrl and c keys,
2) Select cell F2 and press the Ctrl and v keys.
The steps 1 and 2 may be used to apply the formula to column N.
If you don't want the zeros displayed you could use a conditional formatting rule to set the font of cells containing zero to white.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you Jete, I read this over the weekend and thought it would work. I don't know why I never considered taking the information straight from the source. I guess I was so focused on using the pivot since I utilize it for other formuals. Thank You!
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks