Anantha Krishna
Member
Hello All,
I need VBA coding for the below requirement
On File 1 we will be having complete data, so we need only particular data to copy for file 2
E.g on File 1
On File 2 if we need data only for 810278952 which is on the ColumnA then
If we need data for 81027222 then
So can anyone help me on coding based on above requirement.
Regards,
Anantha
I need VBA coding for the below requirement
On File 1 we will be having complete data, so we need only particular data to copy for file 2
E.g on File 1
ColumnA | ColumnB | ColumnC |
810278952 | V090700101 | 20-Feb-19 |
810278952 | V096025001 | 26-Feb-19 |
810278952 | V096025002 | 20-Feb-19 |
810278952 | V092457001 | 21-Feb-19 |
810278952 | V093096001 | 4-Feb-19 |
810278952 | V092382001 | 6-Feb-19 |
810278952 | V133808001 | 18-Mar-19 |
81027222 | V120294001 | 29-Jan-19 |
81027222 | V117963001 | 29-Jan-19 |
81027222 | V162921001 | 29-Jan-19 |
81027222 | V092382001 | 21-Feb-19 |
81027222 | V133808001 | 18-Feb-19 |
On File 2 if we need data only for 810278952 which is on the ColumnA then
ColumnA | ColumnB | ColumnC |
810278952 | V090700101 | 20-Feb-19 |
810278952 | V096025001 | 26-Feb-19 |
810278952 | V096025002 | 20-Feb-19 |
810278952 | V092457001 | 21-Feb-19 |
810278952 | V093096001 | 4-Feb-19 |
810278952 | V092382001 | 6-Feb-19 |
810278952 | V133808001 | 18-Mar-19 |
ColumnA | ColumnB | ColumnC |
81027222 | V120294001 | 29-Jan-19 |
81027222 | V117963001 | 29-Jan-19 |
81027222 | V162921001 | 29-Jan-19 |
81027222 | V092382001 | 21-Feb-19 |
81027222 | V133808001 | 18-Feb-19 |
So can anyone help me on coding based on above requirement.
Regards,
Anantha