how do i reconcile data in cells from old to new spreadsheet
in [General]
|
From: donna on 23 Sep 2009 12:01 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.
From: Dave Peterson on 23 Sep 2009 13:00 There's nothing built into excel that does this automatically. Depending on how your data is laid out (is there a unique key field?) and what you wanted to compare, you may be able to use formulas =vlookup() or =index(match()) (in columns to the right??) to retrieve the values in the new worksheet. Then use additional columns to compare old values to new values. If your data doesn't have any unique key columns, then you could compare address by address (a1 with a1, x99 with x99). If you want to try, take a look at Myrna Larson and Bill Manville's compare program: http://www.cpearson.com/excel/whatsnew.htm look for compare.xla donna wrote: > > 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. -- Dave Peterson
|
Pages: 1 Prev: Apostrophe's becoming upside down question marks on the web Next: Entering HH:MM |