G'day guys.
Need to do a tricky one...
I'm not sure how this can be done with a VBA sub routine. Once the data shifts to another sheet ("DATA Currently") I need to run a VBA script afterwards to convert it into the "Data needs to be" values.
Anyone got ideas? I'm sure there would be a way
[TABLE="width: 500"]
<tbody>[TR]
[TD]Data Currently[/TD]
[TD]Data needs to be[/TD]
[/TR]
[TR]
[TD]3000[/TD]
[TD]3.0[/TD]
[/TR]
[TR]
[TD]11520[/TD]
[TD]11.520[/TD]
[/TR]
[TR]
[TD]982[/TD]
[TD]0.982[/TD]
[/TR]
[TR]
[TD]3100[/TD]
[TD]3.1[/TD]
[/TR]
[TR]
[TD]7211[/TD]
[TD]7.211[/TD]
[/TR]
[TR]
[TD]8400[/TD]
[TD]8.4[/TD]
[/TR]
[TR]
[TD]4122[/TD]
[TD]4.122[/TD]
[/TR]
</tbody>[/TABLE]
Cheers for your help again guys.
Luke
Need to do a tricky one...
I'm not sure how this can be done with a VBA sub routine. Once the data shifts to another sheet ("DATA Currently") I need to run a VBA script afterwards to convert it into the "Data needs to be" values.
Anyone got ideas? I'm sure there would be a way
[TABLE="width: 500"]
<tbody>[TR]
[TD]Data Currently[/TD]
[TD]Data needs to be[/TD]
[/TR]
[TR]
[TD]3000[/TD]
[TD]3.0[/TD]
[/TR]
[TR]
[TD]11520[/TD]
[TD]11.520[/TD]
[/TR]
[TR]
[TD]982[/TD]
[TD]0.982[/TD]
[/TR]
[TR]
[TD]3100[/TD]
[TD]3.1[/TD]
[/TR]
[TR]
[TD]7211[/TD]
[TD]7.211[/TD]
[/TR]
[TR]
[TD]8400[/TD]
[TD]8.4[/TD]
[/TR]
[TR]
[TD]4122[/TD]
[TD]4.122[/TD]
[/TR]
</tbody>[/TABLE]
Cheers for your help again guys.
Luke