Hello,
I am still learning VBA but I have been asked to create a macro for a timesheet for my boss. It is a timesheet where each employee has time recorded weekly and separated by projects. The weekly start date is in Row 1 as a merged cell and the employee's names are in Row 2 followed by all the time below them. It starts at Column S.
In a separate worksheet I have created a small table with Add, Delete, and Date with a hierarchy table below to denote the order they should be in. Also there is a sample row for copying reasons.
What I need to do is create two macros, one to add and one to delete. The one to delete will take the name in Sheet2 and find the name in Row 2 in Sheet1 and delete the columns if they are greater than the date. The second one needs to take the copied cell and, using the hierarchy table as a guide, insert it into columns after the date.
I have been trying it for a while and I have found nothing on the internet that can help with this.
Thanks greatly in advance.
I am still learning VBA but I have been asked to create a macro for a timesheet for my boss. It is a timesheet where each employee has time recorded weekly and separated by projects. The weekly start date is in Row 1 as a merged cell and the employee's names are in Row 2 followed by all the time below them. It starts at Column S.
In a separate worksheet I have created a small table with Add, Delete, and Date with a hierarchy table below to denote the order they should be in. Also there is a sample row for copying reasons.
What I need to do is create two macros, one to add and one to delete. The one to delete will take the name in Sheet2 and find the name in Row 2 in Sheet1 and delete the columns if they are greater than the date. The second one needs to take the copied cell and, using the hierarchy table as a guide, insert it into columns after the date.
I have been trying it for a while and I have found nothing on the internet that can help with this.
Thanks greatly in advance.
