title: EXCEL Any way to copy every iteration result into a separate table?
body: <p>I have a following problem:
  I want to try different  values for say cell A1. Every time I input the value into A1, cells B1, C1, D1 and E1 change. Is there any way to make a new table that would automatically copy results of the of these iterations into separate cells. So for example:
  I choose A1 = 10. This automatically appears at A3. All the values of B1, C1, D1 and E1 are then automaticall stored at B3, C3, D3 and E3. I then change A1 = 20. All new values of B1, C1, D1 and E1 are now stored at B4, C4, D4 and E4. </p>
  
  <p>Any suggestions on how to do that ? 
  Thank you for your time!</p>