S
Snoopy
I'm looking for a general formula for the entire worksheet. My secretary
spends extra time looking for the proper column each time she subsequently
enters a vendors name .
Is there some formula that would recognize the second (third, fourth, etc)
time a vendors name is entered and auto tab to the column that was last used
for that vendor? Also, the same for many different vendors on the same page.
Same question a different way: if the vendor's name were entered a second
time and a different amount were entered could that amount be auto filled in
the column that was used previously on the same worksheeet? Regards
spends extra time looking for the proper column each time she subsequently
enters a vendors name .
Is there some formula that would recognize the second (third, fourth, etc)
time a vendors name is entered and auto tab to the column that was last used
for that vendor? Also, the same for many different vendors on the same page.
Same question a different way: if the vendor's name were entered a second
time and a different amount were entered could that amount be auto filled in
the column that was used previously on the same worksheeet? Regards