solver showing error

[tmshah61]

I have 200 columns and it's total in last column. I want to change my total so it will automatically changes the value with its ratio.





Example

Columns	Value
A	10​
B	20​
C	3​
D	0​
E	50​
F	28​
G	27​
H	38​
I	90​
J	107​
Total	373​

I want change the total to 400 how to do in Excel . I have tried to use solver but it's giving the error message. is there other way to do . i have several rows . I don't want to do manual work. kindly help.





Thanks in Advance

 

[GlennUK]

Have a cell next to your total with the calculated ratio ... like = 400/K2

Then copy that ratio of over the 200 columns, using Paste Special/Values/Multiply. Or do you want something more "automatic"?