LinkBack URL
About LinkBacks
Hello! I've struggled with this for weeks. I've tried Vlookup, but it doesn't give me the results I need. Unfortunately I know very little about VB, but I think that's what I'm going to need. I have a spreadsheet that keeps track of when checklists are received. Each month I run a new report which may have new employees added or the supervisor name changed. I need to check the report that has the checklists received dates in it and update the new list I have run with that info. It would also be great to have it check to see if the employee's status has changed from Active to Terminated, but that's actually the least of my concerns. Basically I need for the newly run sheet to be updated with the entries made on the old sheet. I've attached each sheet so you can see what I'm trying to achieve. Any help would be so greatly appreciated! The "Orientation Checklist Tracking Master" will be the sheet I get the entries from (column J) and would need copied over to the "Employee Tracking Report" to column J as well. Once the info is moved I would name the updated sheet "Orientationch Checklist Tracking Master" and then start all over again next month. Thanks again in advance!
Tara
Register To Reply
I've managed to make it work with Vlookup, but it's a bit time consuming. Each month I run a report of employees then I match it to the previous month's employees. There are three columns which would need updated on the new employees report that would be pulled from the old employee report. If possible, I'd also need for it to look for the termed employees and move them to a different tab. I also sort to keep anyone that is not an RN, LPN, Regional Nurse Manager or Site Manager. (I don't track others) The sheet that has the review dates would need to have those columns copied to the new employee report as well as see if anyone off of the review sheet has been termed and moved to a new tab. I've attached the sheets to help with my explanation. Thanks so much again!
Bookmarks