I have a list of numbers in a column that I wish to update independently from the rest of the sheet

[mgclory]

There may be a better way to do this but I was trying to use What-if Analysis > Data Table.

All I want is to put exactly the same number values from column A into Column B, inside a Data Table. Then I can calculate the column manually with 'Automatic Except for Data Tables'.

What-if Analysis is too advanced for me to understand at this time so any solutions would be greatly appreciated.

 

[mgclory]

went with another solution