title: How to Automatically Copy Cells to Specific Locations in Excel
body: <p>I'm currently working on a spending tracker that looks like this:
  <a href="https://i.stack.imgur.com/2jPQR.png" rel="nofollow noreferrer">Spending Tracker</a></p>
  <p>As you can see, each transaction is sorted consecutively by date and assigned an index number, with each transaction receiving its own row. Each transaction is essentially made of a &quot;Store/Business/Person&quot; text comment, a general text comment, an amount and a category. While this is all helpful information, you can imagine how it would likely get tedious to scroll to each category to enter the correct value.</p>
  <p>My question is, what formulas can I use to copy information from a list such as in this sheet... <a href="https://i.stack.imgur.com/HY9fY.png" rel="nofollow noreferrer">Input List</a></p>
  <p>...into specific places within the main spreadsheet?</p>
  <p>It is essentially a more complicated &quot;='Input List'!C2&quot; formula, however if the pasting destination can change based on if statements.</p>
  <p>Any help with this would be greatly appreciated!</p>