C
Crystal
From: Crystal <[email protected]>
Subject: Auto input in different columns
Date: Tuesday, February 10, 2004 4:07 PM
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 (Auto input
recognized by name)
Subject: Auto input in different columns
Date: Tuesday, February 10, 2004 4:07 PM
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 (Auto input
recognized by name)