i have tax calculation formula based on different states in each sheet. I have downloaded the taxes calculated by the system from database. Now i want to verify this automatically instead of keying the taxes on these sheets. Can i have better idea to do this ?
Example
SHEET 1 - STATE 1 TAX CALCULATION - CONTAINS - FED. TAX, SOC. SECURITY, UNEMPLOYMENT INSURANCE
SHEET 2 - STATE 2 TAX CALCULATION - CINTAINS - - FED. TAX, SOC. SECURITY, UNEMPLOYMENT INSURANCE, STATE TAX AND OTHER DEDUCTIONS
DOWNLOADED VALUES FROM DB2
STATE TAX SOC. SEC. UNEM.INSU STATE TAX OTHER DED.
1 ....
2...
1..
2..
what i need here, i have to choose the right sheet (1 or 2 ) based on state code from the data base values and send the values of the taxes and other deductions to that sheet and get the tax calculation from the sheet and compare with the taxes downloaded from the db.
Is this possible in excel?
Thanks
Jai
Bookmarks