Hello there, I have a couple of queries I am struggling with and I am after some assistance.
I have a "Data" tab with columns of data fields, and a user form which can Add to the next available row, and another user form which can find them via a drop down bringing back all of the fields into the user form. I want to basically use the 2nd form to be able to "update" data fields.
For example, I want the value of TextBox1 to change in the data if I change it in the userform and click update. The bit below where this is wrong is in the "currentrow" selection as this is not clearly defined- is there another way I can update the data using a vlookup function? The key reference field is called cboref and is a drop down in my user form e.g. if cboref has a match in my data and I click update then whatever I have in the user form for TextBox1.Text I want it to update the value in column 3 of that row where there is a match on cboref....
The second query I have is around row entries- I have a list of certain tasks which are due on different days e.g. every Monday, or monthly e.g. third wednesday of every month etc. I want some criteria which can look up the frequency of the task, match it to the data sheet and if the task before todays date has been marked as 100% complete in the 'progress' column, I want vba to automatically copy that row, paste it to the next available row in the data with the next date due (based on the frequency). I guess this could be tricky to code up and we may need something to check the days that the task is duePlease Login or Register to view this content.
Kind regards
Bookmarks