LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default ToolsAutoCorrect options...Where's this data file on my PC?


Hello Excellers,

The AutoCorrect function has proven to be an amazing time-saver for my
company. We use it to enter customer names and even complete addresses
w/ phone #s etc. into our spreadsheets.

For example: just by typing a three letter code like *jsk* and then
hitting ENTER (or spacebar or any punctuation), it saves us from typing
John Smith Kitchens, Inc. And by entering *jsk1*, we've got Excel
correcting it as:

John Smith Kitchens, Inc.
123 Main Street
Theirtown, NH 55555
(603)555-5555 Phone
(603)555-5556 Fax

Entering the 100+ company names & addresses took some time up front but
was worth every keystroke for the time it is saving us now.
_The_problem_is_this...I'd_like_to_import_this_Aut oCorrect_data_into_other_PC's_in_our_office,_but_I _don't_know_if_there_is_a_way_to_do_it._Is_there_a _way_to_export_this_data_or_locate_the_hidden_data _file_on_the_1st_PC_and_drop_it_in_the_next_PC_in_ the_appropriate_place_where_Excel_will_find_it?_


Any help would be greatly appreciated. Thanks in advance!:)

Troy

(BTW: Most of our PCs are using Windows XP and Excel 2003 with the
exception of 1 using W2000 and 1 using W98.)


--
Douglas23
------------------------------------------------------------------------
Douglas23's Profile: http://www.excelforum.com/member.php...o&userid=36177
View this thread: http://www.excelforum.com/showthread...hreadid=559564

 
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
Using Relative path for XML data file? Mark W. Robbins Charts and Charting in Excel 0 June 7th 06 06:41 AM
Importing data over intranet creativeops Excel Discussion (Misc queries) 0 May 22nd 06 11:43 PM
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
MAKING A CONTRACT FROM DATA FROM A DIFFERENT FILE MCNAB Excel Worksheet Functions 0 July 28th 05 03:11 PM
File Error: Data May Have Been Lost Tbird2340 Excel Discussion (Misc queries) 8 March 20th 05 05:31 PM


All times are GMT +1. The time now is 05:14 PM.

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

About Us

"It's about Microsoft Excel"