Thecraftycarrot
New Member
- Joined
- Nov 8, 2018
- Messages
- 27
Hi All,
good morning!
What i am trying to do is when 2 sets of criterion are met (e.g. Name match not blank, and then if another cell is "yes") i want to copy the data from the input form and into that specific row (for the individual with that name that has been matched) which has been contained in a separate data sheet to the input form- difficulties the form does not capture the data in a way that one copy and paste will do, i will need multiple.
Secondly, if the answer is no, i want to create a new line item at the bottom of the table (in the separate worksheet to the form) and then copy the list of relevant data into this newly created row
i hope this makes sense? i dont know where to start as i am very, very new to using vba
regards
good morning!
What i am trying to do is when 2 sets of criterion are met (e.g. Name match not blank, and then if another cell is "yes") i want to copy the data from the input form and into that specific row (for the individual with that name that has been matched) which has been contained in a separate data sheet to the input form- difficulties the form does not capture the data in a way that one copy and paste will do, i will need multiple.
Secondly, if the answer is no, i want to create a new line item at the bottom of the table (in the separate worksheet to the form) and then copy the list of relevant data into this newly created row
i hope this makes sense? i dont know where to start as i am very, very new to using vba
regards
