Thread: Data Entry
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John
 
Posts: n/a
Default Data Entry

Skip

Have two columns, say your entry column is ColA, type in here then non
standard numbers eg assuming they are the last 5, in ColB have the formula
=C1&A1

In C1 enter your standard numbers that will appear on every enter

Eg C1 = 6; A1 = 12345, thus B2 with the formula above will return 612345


HTH



"Skip" wrote in message
oups.com...
Some of the data I enter is 12-15 key strokes long. Many of these
entries are the same. Are there any shortcuts available, that allow me
to reduce the typing required to enter this data? Thanks