1. So you are say having some allocated of xx lacs and a running portfolio of y no of stocks.
2. Now you want to add /remove some capital to this
3. Go to the utility on the master-sheet and add the proposed capital amount on the top right orange box
5. Once purchased (sold), for each stock, now you have to manually (or on excel) calculate your now total qty and average price and replace in the appropriate columns (in your sheet).
7. This should be it. If errors try to see if can fix it else go to File>version history> and restore the version before changes and do all over again.