Hello everyone.
I'm a very begginer VBA user, but I have a problem that i have been fighting with for almost 2 weeks now, and I can't solve it myself. I will be really grateful if someone will able to help. I can only describe it, without sharing any data, beacuse it's work related excercise.
I need to copy and paste the values from one workbook to another based on criteria:
1. Both worksheets have matching headers, but there are more of them in the destination workbook so the macro have to capture only the matching ones.
2. Column in sourcefile - A1 and destfile DI8 has the header ID where in the rows are stored specific ID that should be matched.
3. If there is No match id or in destfile ID is '-' the values in matching column should be "-", duplicates also May come up so i would need the data to be pasted to all matches, not just the first.
I know it's a lot but i tried my best and failed.
I appreciate any help.
Kamil
I'm a very begginer VBA user, but I have a problem that i have been fighting with for almost 2 weeks now, and I can't solve it myself. I will be really grateful if someone will able to help. I can only describe it, without sharing any data, beacuse it's work related excercise.
I need to copy and paste the values from one workbook to another based on criteria:
1. Both worksheets have matching headers, but there are more of them in the destination workbook so the macro have to capture only the matching ones.
2. Column in sourcefile - A1 and destfile DI8 has the header ID where in the rows are stored specific ID that should be matched.
3. If there is No match id or in destfile ID is '-' the values in matching column should be "-", duplicates also May come up so i would need the data to be pasted to all matches, not just the first.
I know it's a lot but i tried my best and failed.
I appreciate any help.
Kamil
