navinaaaaaa
Board Regular
- Joined
- Mar 22, 2009
- Messages
- 50
i have got 2 sheets in a workbook
sheet 1 has data as below
col1 col2
817315 0.4
897228 0.6
805002 1.2
899892 0.6
897228 0.01
805002 1.8
817315 1.2
sheet 2 has format as below
col1 col2
805002 =1.2+1.8
897228 =0.6+0.01
899890 =0.6
817315 =0.4+1.2
how can i update sheet 2 from sheet1 using macros?
sheet 1 has data as below
col1 col2
817315 0.4
897228 0.6
805002 1.2
899892 0.6
897228 0.01
805002 1.8
817315 1.2
sheet 2 has format as below
col1 col2
805002 =1.2+1.8
897228 =0.6+0.01
899890 =0.6
817315 =0.4+1.2
how can i update sheet 2 from sheet1 using macros?