Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Auto tab- Auto fill
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Auto Fill | Excel Discussion (Misc queries) | |||
stop auto fill from thinking for itself!!!!!!! | New Users to Excel | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
Auto fill option box disappeared | Excel Worksheet Functions | |||
Auto Fill Options | Excel Discussion (Misc queries) |