Hello Everyone,
Im currently struggling to solve this simple problem. So basically,
I have a time and motion study tracker with start, end and submit button button. I managed to worked on start and end.
But I am struggling to submit an specific data to my masterfile. In my workbook, I have a dropdown selection of status.. If the value of the dropdown is Pending, then those cases should be submitted in my Archive workbook when I hit the Submit button and the status in my last column will be updated to Submitted. So it will exclude those cases on my next submission and should not overlap the data in my master file.
Below is my current code.
Im having an error that destination not found.
Im pretty sure my path is correct =(
I also attached the image of my source and masterfile.
Source.jpg
masterfile.png
Thank you In Advance guys for your help.. =)
I;m not sure if Loop is reqd for this code. Just wanted to ask someone who c an fix this =(
Bookmarks