I’ve tried searching for a solution for this but haven’t found it yet. I see the small asset tracker for Google Sheets which is close but not what I need (and I don’t use Sheets).
I am building a new worksheet in my Tiller Excel workbook to track all of my collectibles, the cost, the value and other data about them I’d like to track. I may categorize the collectibles as well so that I can have subtotals by category. My ultimate goal is to include everything I track on this new sheet as one or more manual accounts in my Tiller data.
I can’t find any information on how to create or update a manual account outside of the Tiller add-in. Using the tool to create the manual account initially is not a big issue, but I really need to be able to have the value of the manual account update automatically based on the subtotals pulled from my collectible tracking sheet.
I don’t need help with building the tracking sheet as I can do that myself. I just need a method for (i) updating the value of a manual account based on data in another sheet in the worksheet and (ii) if possible, creating manual accounts without using the Tiller add-in tool.