View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
YaYa YaYa is offline
external usenet poster
 
Posts: 2
Default how do i copy data from one sheet to another by d clicking a cell

i have two worksheets. one store inventory and one sales reciept. all
products have item number in first column. when i sell an item, i want to be
able to double click that cell and auto copy other data in that row to the
sales reciept worksheet.
thanks