I have a Spread sheet where on Monday-Sunday we have individual employees and their sales, and the days are separated on different pages. To input the employees there is a data validation drop down menu with all the names. at the end of the week we have a totals page that need to add up their sales from the entire week. the problem i am having is the totals page. i need help making sure that when you select the name on the last page it recognizes their sales.
I don't see any data validation dropdowns. Are those supposed to in B5:B34 of each of the day sheets? Are the employees on each day sheet different?
If I am guessing right you need to use a SUMIF on the Totals sheet, but to be more specific I would need to understand the above.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
I'm guessing he's going to need a 3D SUMIF construct.
Your workbook is pretty, but not very helpful for this exercise. A "sample" workbook includes sample data on all the data sheets, as randomly placed as you would normally expect it to be. Then on your TOTALS sheet you manually mockup the "results" and point out the cells you want help automating. This helps us help you, you show us the end result.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks