Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Snoopy
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro for Auto Fill carolini Excel Discussion (Misc queries) 2 December 6th 05 10:11 PM
stop auto fill from thinking for itself!!!!!!! 1vagrowr New Users to Excel 3 November 5th 05 04:27 PM
Auto Fill Options adarling Excel Discussion (Misc queries) 1 April 8th 05 03:09 AM
Auto fill option box disappeared sbrimley Excel Worksheet Functions 5 February 4th 05 04:21 AM
Auto Fill Options Patti B Excel Discussion (Misc queries) 3 December 9th 04 01:49 AM


All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"