TIMESHEET 2013sample.xlsx
Hello - i think i have simplified my question (from a few days ago) to be better understood:
I need just a few major things that i'm not sure if it can be done and how - the rest i'm OK with.
1. I have an employee info form (sheet) with cells (merged and regular) for Name, Address, SSN, hourly rate, bank account info, etc. I need to figure a way to require all the "required" cells, before entering the employee name and hourly rate/salary on another sheet where my clients would enter the payroll hours - that way i am not trying to use my crystal ball to figure out how much to pay these guys!
2. Then, i need a way to (probably a button type operation) that will create a blank employee info form (sheet) to then be filled in with a second employee's info, so they can put the hours in for them as well, and so on, with the name being at least some part of the employees name.
3. With that said, i'd also like to be able to take the sheet with a certain pay periods hours on it, and create a blank sheet for the next pay period.
4. Lastly, if there's a way to summarize, on another separate sheet in the same file, the employee's names, addresses into columns. Example: EmployeeInfo1 cell A1 to SummarySheet A1. EmployeeInfo2 cell A1 to SummarySheetA2. And have them in alphabetical order. I have a basic idea.. with still a few major tweaks on my end, but basically this is a tiny insight into my screwed up brain and how I got it to do a few things i wanted. There is definitely a better and easier and more efficient way to do what i've done so far. If you want to share any other routes, feel more than welcome.
Thanks in adavnce, i'm attaching a sensitive data omitted sample of what i'm talking about. Don't laugh. OK.. you can laugh.
Bookmarks