Vacation Tracking
I have 4 different groups that accrue vacation at various rates. I have set
up a table with each of these groups in one worksheet. In a separate worksheet I have the time taken by each of the employees. This spreadsheet contains the codes needed to identify which group the employee belongs to. Also, I have a field that calculates the # of years an employee has been with the company. I need to take the number of years column, let's call it AI and the Code for the proper Group, let's call it B, and with this go to spreadsheet where the table sits and find the right group and pull in the proper accrual rate. Any ideas???? |
Vacation Tracking
I can see that you haven't received an answer to your question in a few days
now. Perhaps people don't really understand what you are talking about (I'm sorry, but I don't have a clue what you are talking about). Please elaborate on your initial idea. Describe the issue with more details and you will probably get a detailed response. Regards, Ryan--- -- RyGuy "NewAccessUser" wrote: I have 4 different groups that accrue vacation at various rates. I have set up a table with each of these groups in one worksheet. In a separate worksheet I have the time taken by each of the employees. This spreadsheet contains the codes needed to identify which group the employee belongs to. Also, I have a field that calculates the # of years an employee has been with the company. I need to take the number of years column, let's call it AI and the Code for the proper Group, let's call it B, and with this go to spreadsheet where the table sits and find the right group and pull in the proper accrual rate. Any ideas???? |
All times are GMT +1. The time now is 09:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com