Hi All,
Need your help.i have requirement where i have following data
sheet 1
--------
data value
----- -----
test1 4
test2 0
test 3 0
test4 6
test7 1
sheet 2
--------
data1 data2 value
<tbody>
</tbody>
i have sheet1 where there are 2 columns data and value and sheet 2 which has 3 columns.i need to populate the sheet 1 values in the sheet 2 values based on the below criteria
search for the value of the column "data" in the sheet 2 and populate the non zero value in sheet 2.the columns are dynamic in sheet 1
Thanks
pal
Need your help.i have requirement where i have following data
sheet 1
--------
data value
----- -----
test1 4
test2 0
test 3 0
test4 6
test7 1
sheet 2
--------
data1 data2 value
test1 | test2 | 4 |
test3 | test4 | 6 |
test6 | test7 | 1 |
<tbody>
</tbody>
i have sheet1 where there are 2 columns data and value and sheet 2 which has 3 columns.i need to populate the sheet 1 values in the sheet 2 values based on the below criteria
search for the value of the column "data" in the sheet 2 and populate the non zero value in sheet 2.the columns are dynamic in sheet 1
Thanks
pal