View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pm pm is offline
external usenet poster
 
Posts: 122
Default copy sales volume data from sheet 2 to sheet 1 by sales person

Sheet two has sales person and last month volume. Sheet one has sales person
and current volume. i want to find corresponding sales person on sheet 1 and
copy the volume from sheet two.
Any other way to do this besides a macro?