I am looking for advice as to the best way to set something up, I have this page which is used to show which employees are needed on specific job sites each day.
This is what I have in a tab named labor info
The idea is that different team leaders will submit what job they are on and who they will need vs. will not need on their crew the next day.
When someone clicks the add button I want the information to be filled into a second tab named "dailylabor".
This is what the second sheet looks like:
My intention is to continue adding columns so that today's date is always in C1 and tomorrow is B1.
When the add button is clicked, I need it to look at
Sheets("LaborInfo").Range("C2:C100") and find the matching name in Sheets("DailyLabor").Range("A2:A100") and then if Sheets("LaborInfo").Range("D2:D100") put the value in Sheets("LaborInfo").Range("B2") into Sheets("DailyLabor").Range("B2:B100")
My problem is that this will be submitted multiple times and I don't want it to overwrite information. At first I was thinking abouut doing something where it inserts a formula (vlookup) but that would return an error in all the ones that do not match and overwrite.
So instead I am thinking it should be an if else loop but I don't know how to deal with the part where it needs to find the correct name.
I hope this was clear and please let me know how I can make it more clear.
This is what I have in a tab named labor info
The idea is that different team leaders will submit what job they are on and who they will need vs. will not need on their crew the next day.
When someone clicks the add button I want the information to be filled into a second tab named "dailylabor".
This is what the second sheet looks like:
My intention is to continue adding columns so that today's date is always in C1 and tomorrow is B1.
When the add button is clicked, I need it to look at
Sheets("LaborInfo").Range("C2:C100") and find the matching name in Sheets("DailyLabor").Range("A2:A100") and then if Sheets("LaborInfo").Range("D2:D100") put the value in Sheets("LaborInfo").Range("B2") into Sheets("DailyLabor").Range("B2:B100")
My problem is that this will be submitted multiple times and I don't want it to overwrite information. At first I was thinking abouut doing something where it inserts a formula (vlookup) but that would return an error in all the ones that do not match and overwrite.
So instead I am thinking it should be an if else loop but I don't know how to deal with the part where it needs to find the correct name.
I hope this was clear and please let me know how I can make it more clear.
