Hello! I am trying to automate a few things for the purposes of taxes/ accounting and unfortunately I just can't figure out a way to do the following:
Sheet 1 "Data Entry"= Drop down lists (Yes/No) and amounts that correspond to questions such as "Are there any disallowable expenses in X".
Example:
"Are there any disallowable expenses in management fees? [Drop down - Yes/No] [ Amount]"
(The first page will consist of 10-15 of such examples with other tax sensitive expenses such as depreciation, amortization and so on. Bank Interest Income is an item that would go into the 'Less' section while management fees would go into the Add section. BONUS POINTS - if you can make the amount box appear of disappear if the drop down=No :D)
Sheet 2 "Adjusted Profits"= If the answer is Yes to any of the previous page's question's it will either be added to a "Add" or "Less" list like this -
Profit per the accounts: 16500
Add:
"Disallowable Management Fee ....500"
Less:
"E.g. Bank Interest Income....200"
Adjusted Profit: 16...
As you can see it will need to be able to expand according to the number of possible additions or subtractions to the profits.
Finally the formatting will require that the "Adjusted Profit" figure be left with a space at the bottom of whichever is last on the list of either the Less or Add depending on whether there are any to put in the first place.
If anyone could be so kind as to help me with this then I would be very grateful indeed Of course if there is a way that I can repay your skills then please do let me know - I hear there is a Steam sale on!
Bookmarks