View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gatz gatz is offline
external usenet poster
 
Posts: 9
Default auto entry of data on keystrokes

If we set up 1 sheet of sorted data within a "book", then go to another
sheet 2 to have some (or many) of these data copied to a column in sheet 2
that is then used for a customer quote sheet, with perhaps subtotals and
grand totals

For instance, say we have 150 products which we can sort by name/size/price
that we've entered in sheet 1.

Then, on the 2nd sheet, after placing the cursor on a particular column/row
we'd like to use a simple numeric keyboard (AltXXX, maybe?) entry that
corresponds to what's on sheet 1.
We'd print out sheet 1 for quick reference.

Or, has anyone got a better idea/plan ?
Thanks