I have a time sheet that uses several list boxes in Column A (1 to 40) The list boxes look at another tab in my workbook, called "Rate Chart". When you choose an employee name the list boxes return a number associated with the selection. I then have this number do a vlookup to grab the rate for that employee and returns it in column G. That all works great. The problem is that on my time sheet summary I am having problems summarizing the instances where I am using an employees name more than once. Can I send a spreadsheet or post to you to look at? It is a complex question and it is not straight forward to just write down a formula.
-
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.
List Boxes
- Thread starter Speedring
- Start date
GlennUK
Well-known Member
- Joined
- Jul 8, 2002
- Messages
- 11,871
- Office Version
- 2019
- 2013
- Platform
- Windows
Show some of your sheet:
Display sheet using MrExcel HTML Maker or Excel Jeanie
http://www.mrexcel.com/forum/showpost.php?p=2545970&postcount=2
http://www.excel-jeanie-html.de/index.php?f=1
Display sheet using MrExcel HTML Maker or Excel Jeanie
http://www.mrexcel.com/forum/showpost.php?p=2545970&postcount=2
http://www.excel-jeanie-html.de/index.php?f=1
Upvote
0
Displaying the sheet looks harder than fixing the formulas I have. Just kidding
Once I figure it out I will post it
thanks
Upvote
0
