A little knowledge can be dangerous, reading this board keeps giving me ideas on how to make some spreadsheets more useable. I have a question about userform functionality. I have a workbook, which contains data provided from multiple sources, i.e. quickbooks and a scheduling system. One of the sheets contains dates, customers and total job hours in columns 1-3 and employees who worked on the job and the employees’ estimated hours next to their name in columns 5-25.
Every two weeks we get in timesheets from the employees and I created a pivot table to help us check the timesheets. This works ok for checking the time but if we need to make an adjustment, we need to go into the worksheet and search for the /date/customer/employee and update the adjusted hours.
What I would like is to create a userform where we can select the employee name from a list and then use the selected name to look in all of the columns and rows were the employee name might be and if found return column 1,2,3 from that row in addition to the cell offset 1 column (Est Amount) from the found employee name and the cell offset 1 column and 1 row (Actual Amount). I would like to be able to edit the actual amount and have it placed back into the appropriate cell.
Sorry this is so long. I am using excel 2000.
Thanks for the help
- Joseph
Every two weeks we get in timesheets from the employees and I created a pivot table to help us check the timesheets. This works ok for checking the time but if we need to make an adjustment, we need to go into the worksheet and search for the /date/customer/employee and update the adjusted hours.
What I would like is to create a userform where we can select the employee name from a list and then use the selected name to look in all of the columns and rows were the employee name might be and if found return column 1,2,3 from that row in addition to the cell offset 1 column (Est Amount) from the found employee name and the cell offset 1 column and 1 row (Actual Amount). I would like to be able to edit the actual amount and have it placed back into the appropriate cell.
Sorry this is so long. I am using excel 2000.
Thanks for the help
- Joseph