View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Donna Donna is offline
external usenet poster
 
Posts: 180
Default how do i reconcile data in cells from old to new spreadsheet

each week my spreadsheet lists 300 records w/20+ columns each. how do i
reconcile data in cells from old to new spread w/o manually copy/paste? is
there a reconcile option? i would only want to paste data in columns k and l
from old spreadsheet to new and only if the record number matches both the
previous week's report and current week's report match.