Hello,
please if somebody can help me.
<tbody>
[TD="class: votecell"][/TD]
[TD="class: postcell"] I have this problem: in excel file I have two sheets. In first sheet I am entering values, changing values, deleting values...sometimes, in one cell I enter value like this 125+138+458.
I need to copy values into next sheet, but only values that have been first entered into first sheet.
maybe I need some VBA here...but I don't know how to write that VBA code.
example: in first sheet we enter <code>111</code> to <code>A1</code>, then enter <code>222</code> to <code>A1</code>, I want <code>111</code> to show up on second sheet in cell A1.
or if I write in B1 =100+200+300, I want to show up on second sheet in cell B1 only value 100.
[/TD]
</tbody>
please if somebody can help me.
<tbody>
[TD="class: votecell"][/TD]
[TD="class: postcell"] I have this problem: in excel file I have two sheets. In first sheet I am entering values, changing values, deleting values...sometimes, in one cell I enter value like this 125+138+458.
I need to copy values into next sheet, but only values that have been first entered into first sheet.
maybe I need some VBA here...but I don't know how to write that VBA code.
example: in first sheet we enter <code>111</code> to <code>A1</code>, then enter <code>222</code> to <code>A1</code>, I want <code>111</code> to show up on second sheet in cell A1.
or if I write in B1 =100+200+300, I want to show up on second sheet in cell B1 only value 100.
[/TD]
</tbody>
