Please see Investment Portfolio Tracker - TMOAP Official Version 5.2.

If the three columns (in red rectangles) remain the same for rows 5-20, it's obviously foolish and unproductive to click on the drop-down menu and pick the same three specifics (VA, Buy, RRSP) 48 (16 x 3) times.

Thus how can I be more productive, and click on the drop-down menu and pick merely 3 times (once for each of the three columns)?

enter image description here


Instead of doing it individually for each cell, you are able to apply it to the whole range at once by adding :C at the end like:


To override multiple cells in the range you are able to reference the start point and then manage the whole area just from one cell. For example, if you paste =C$5 into C6 cell and drag down to reach C15 then you are able to influence C6:C15 directly from C5 cell:


  • Suppose that C6-C15 are for stock purchases. Then "Cell range" is Trade Log!C6:C15. I just tried this, but this Cell Range doesn't cause the drop-down menus to select 'Buy' automatically? Can you please add more detail to the post?
    – NNOX Apps
    Jun 6 '19 at 2:36
  • @TamaraM. answer updated
    – user0
    Jun 6 '19 at 7:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.