Copying, then deletion of value dependent on another cells value

[stovvy]

I can find similar posts on the forum but not exactly what I would require. I have exhausted all of my slim knowledge in both Excel and VBA in trying to complete the task so please is there someone out there who can help?

I have a spreadsheet and in column B2 it would show a numerical value that is totalled in B1. Dependent on what is shown A2 (an asterisk, etc) the value in B2 is copied to C2 but the value then is removed from B2. This would be duplicated down across the columns with the totals appearing in the Row 1 columns.

I hope this makes sense?

 

[SteveO59L]

try posting a sample of your data, and what you would like to do with it

 

[stovvy]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]£801.82[/TD]
[TD="align: center"]£597.77[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Vendor 1[/TD]
[TD="align: center"]£250.00[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Vendor 2[/TD]
[TD="align: center"]£180.56[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]Vendor 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]£310.00[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]Vendor 3[/TD]
[TD="align: center"][/TD]
[TD="align: center"]£230.65[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Vendor 4[/TD]
[TD="align: center"]£195.67[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Vendor 5[/TD]
[TD="align: center"]£80.14[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Vendor 6[/TD]
[TD="align: center"]£65.45[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Vendor 7[/TD]
[TD="align: center"]£30.00[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]Vendor 2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]£37.85[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"]Vendor 8[/TD]
[TD="align: center"][/TD]
[TD="align: center"]£19.27[/TD]
[/TR]
</tbody>[/TABLE]

I would like to be able to input values into Column C and then as the flag is ticked in Column A, the value in Column C is moved to Column D and deleted from Column C but with the Totals in Line 1 not being affected.

Many thanks for any help