I am trying to create a series of documents which will auto reference themselves; these documents are of financial nature and the query begins with one level of the series - auto tax references.
In one sheet of this tax calculator I have copied an auto-updating cell reference to other workbooks, which holds the estimated annual income for my finances. Another sheet holds the federal tax statements, and I have been able to manage to use the lookup function to determine the appropriate tax bracket for my income; however the issue comes when trying automatically determine provincial tax brackets.
The goal with the sheet referencing provincial tax bracket is to have a drop down list which serves as the main reference point; this list is the selection panel which would be used to have a formula below update to reference the correct tax information for that province.
I have all of the provincial tax information listed in one section of this sheet; but I have been unable to figure out a way to list the correct information.
The goal is to have the sheet essentially fall into this template:
Current province of residency - [drop down list]
Salary Range Tax Rate
[Low] [High] [Percentage]
- - -
- - -
- - -
- - -
- - -
- - -
Where - marks cell data determined by the drop down list.
In one sheet of this tax calculator I have copied an auto-updating cell reference to other workbooks, which holds the estimated annual income for my finances. Another sheet holds the federal tax statements, and I have been able to manage to use the lookup function to determine the appropriate tax bracket for my income; however the issue comes when trying automatically determine provincial tax brackets.
The goal with the sheet referencing provincial tax bracket is to have a drop down list which serves as the main reference point; this list is the selection panel which would be used to have a formula below update to reference the correct tax information for that province.
I have all of the provincial tax information listed in one section of this sheet; but I have been unable to figure out a way to list the correct information.
The goal is to have the sheet essentially fall into this template:
Current province of residency - [drop down list]
Salary Range Tax Rate
[Low] [High] [Percentage]
- - -
- - -
- - -
- - -
- - -
- - -
Where - marks cell data determined by the drop down list.
