tommy1234
03-07-2015, 01:03 AM
Hello
i have 2 sheets that i want to copy values between them.
the problems are :
1.that sheet1 has 100 items and sheet2 has 60 items (all of them included in sheet1).
2.the number of columns for each item is different and i want to copy to sheet1 only the max values column (need to be calculated)
sheet1 has 40 items which are different, so i dont want to delete them when copy the values from sheet2 to sheet1
thank you
item
price1
price2
price3
max
a
2.5
2.5
b
6
6
c
10.1
10.9
10.9
d
5
5.3
5.4
5.4
e
4
2
1
4
f
4.11
5.88
5.88
i have 2 sheets that i want to copy values between them.
the problems are :
1.that sheet1 has 100 items and sheet2 has 60 items (all of them included in sheet1).
2.the number of columns for each item is different and i want to copy to sheet1 only the max values column (need to be calculated)
sheet1 has 40 items which are different, so i dont want to delete them when copy the values from sheet2 to sheet1
thank you
item
price1
price2
price3
max
a
2.5
2.5
b
6
6
c
10.1
10.9
10.9
d
5
5.3
5.4
5.4
e
4
2
1
4
f
4.11
5.88
5.88