Hello Experts,
I have been working on a report for my team and have received a lot of help from this forum + the internet This particular requirement is a bit tricky for me and I am not able to put together a working VBA code for it. Let me explain the requirement:
Look at example above. Assume this is the entry a user has done for today in a sheet named "Entry". After he clocks on the SAVE button, this data gets saved in the "Data" sheet and all data from the Entry sheet is cleared. Code already written for this. You can see there are are two rows with the status as "WIP".
Now, let's say the user comes in to work next day, and wants to see whatever lines contain "WIP", complete the work, and then change the status to "Completed" manually and save it back. The purpose of this is to check when was the work completed.
Requirements:
1. The user can only pull up those lines from the "Data" sheet, which have status as "WIP"
2. He can only change the status on those lines from "WIP" to "Completed"
3. Save it back to the "Data" sheet, which will overwrite the previous lines, which had WIP in them
4. The system date column should pick the system date, duh!, so that the delay to complete the work can be looked at (system date minus req. date)
Thank you, in anticipation.
I have been working on a report for my team and have received a lot of help from this forum + the internet This particular requirement is a bit tricky for me and I am not able to put together a working VBA code for it. Let me explain the requirement:
Look at example above. Assume this is the entry a user has done for today in a sheet named "Entry". After he clocks on the SAVE button, this data gets saved in the "Data" sheet and all data from the Entry sheet is cleared. Code already written for this. You can see there are are two rows with the status as "WIP".
Now, let's say the user comes in to work next day, and wants to see whatever lines contain "WIP", complete the work, and then change the status to "Completed" manually and save it back. The purpose of this is to check when was the work completed.
Requirements:
1. The user can only pull up those lines from the "Data" sheet, which have status as "WIP"
2. He can only change the status on those lines from "WIP" to "Completed"
3. Save it back to the "Data" sheet, which will overwrite the previous lines, which had WIP in them
4. The system date column should pick the system date, duh!, so that the delay to complete the work can be looked at (system date minus req. date)
Thank you, in anticipation.