Removing and pasting from other cells Value

[aliikhlaq2006]

Hi, I have more then thousands rows of data and sample is attached in the table Column D is equal to =Sum(A-B-C) and D should not be lower then 0

A	B	C	D
10000	8000	5000	-3000

What i want result is "If i remove the column C the initially D will become 2000 and that should be copied to C and Finally D becomes the 0 as per formula"

 

[Muhammad_Usman]

You can do it by helper column

Book1.xlsm
	A	B	C	D	E
1					Helper Column
2	10000	8000	5000	-3000	2000
3	5000	2000	6000	-3000	3000
4	10000	2000	9000	-1000	8000
5				0	0
6				0	0
7				0	0
8				0	0
9				0	0
10				0	0
11				0	0
12				0	0
Sheet1

Cell Formulas
Range	Formula
D2:D12	D2	=A2-B2-C2
E2:E12	E2	=C2+D2

Then Copy helper column and past Values only to column C

Book1.xlsm
	A	B	C	D
1
2	10000	8000	2000	0
3	5000	2000	3000	0
4	10000	2000	8000	0
5			0	0
6			0	0
7			0	0
8			0	0
9			0	0
10			0	0
11			0	0
12			0	0
Sheet1

Cell Formulas
Range	Formula
D2:D12	D2	=A2-B2-C2

 

[aliikhlaq2006]

You can do it by helper column

Book1.xlsm
	A	B	C	D	E
1					Helper Column
2	10000	8000	5000	-3000	2000
3	5000	2000	6000	-3000	3000
4	10000	2000	9000	-1000	8000
5				0	0
6				0	0
7				0	0
8				0	0
9				0	0
10				0	0
11				0	0
12				0	0
Sheet1

Cell Formulas
Range	Formula
D2:D12	D2	=A2-B2-C2
E2:E12	E2	=C2+D2

Then Copy helper column and past Values only to column C

Book1.xlsm
	A	B	C	D
1
2	10000	8000	2000	0
3	5000	2000	3000	0
4	10000	2000	8000	0
5			0	0
6			0	0
7			0	0
8			0	0
9			0	0
10			0	0
11			0	0
12			0	0
Sheet1

Cell Formulas
Range	Formula
D2:D12	D2	=A2-B2-C2

Ok That will be great but i have some hidden rows between the data so copying pasting will not work so how i do that ?

 

[aliikhlaq2006]

Hidden row contains the data where the D is either 0 or greater then 0 so i think this will not work out