elsuji
12-05-2019, 10:43 AM
Dear Team,
I am having two sheets (Sample 1 and sample 2).
I need to copy data from sheet 2 to sheet 1.
I am having two columns named on Model (Column B) and M/c Sl.No (Column C) on sheet 1. In sheet 2 also the same columns available. I need copy the datas of Column I to R and update to sheet 1 where the column B & C are matching on Sheet2.
For example in sheet 1 Model: CP18 and M/c Sl.No : BP317. In sheet 2 the same to be check and copy the datas.
The sample files are attached here for your reference.
Can any one help me how to copy my datas easily
I am having two sheets (Sample 1 and sample 2).
I need to copy data from sheet 2 to sheet 1.
I am having two columns named on Model (Column B) and M/c Sl.No (Column C) on sheet 1. In sheet 2 also the same columns available. I need copy the datas of Column I to R and update to sheet 1 where the column B & C are matching on Sheet2.
For example in sheet 1 Model: CP18 and M/c Sl.No : BP317. In sheet 2 the same to be check and copy the datas.
The sample files are attached here for your reference.
Can any one help me how to copy my datas easily