C
Crystal
I have a workbook that I input customer sales. I then have to look up in
another tab (same workbook) what county that customer is taxable in. I then
have to copy the base sales amount into that county. Is there a way for me
to merge the infomation on the county taxable worksheet with the master
sales data worksheet so that when I input the following scenario it would
automatically copy the base amount I enter into the corresponding county
taxable column?:
Customer Sales Tax Taxable in (County Name)
ABC Co $1.00 .08 $1.00 (Automatically
entered due to formula?)
Can anyone tell me exactly what the formula would be? Let's say the main
sheet is called Ledger (where I actually do the entering) and the taxable
information is called TaxList. What would I enter to get it to recognize
that customer ABC is taxable in county XYZ? Any ideas?
another tab (same workbook) what county that customer is taxable in. I then
have to copy the base sales amount into that county. Is there a way for me
to merge the infomation on the county taxable worksheet with the master
sales data worksheet so that when I input the following scenario it would
automatically copy the base amount I enter into the corresponding county
taxable column?:
Customer Sales Tax Taxable in (County Name)
ABC Co $1.00 .08 $1.00 (Automatically
entered due to formula?)
Can anyone tell me exactly what the formula would be? Let's say the main
sheet is called Ledger (where I actually do the entering) and the taxable
information is called TaxList. What would I enter to get it to recognize
that customer ABC is taxable in county XYZ? Any ideas?