Comparing two versions of the same worksheet

tlingit · Mar 14th, 2002, 12:49 PM

Can anyone tell me how? Passed a copy of s sheet to a client who, rather than making changes in a single column, changed things everywhere with no revision tracking at all.

tk19 · Mar 14th, 2002, 01:14 PM

one idea is to put the two sheets next to each other in the same workbook (renaming one of them). For example, if one is named "MyVersion" and the other "ClientVersion" then add a new sheet, and in the new sheet's cell A1, put:
if(MyVersion!A1<>ClientVersion!A1,"***","")
then "***" will show up if they're different.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 12:49 PM	#1
tlingit New Member Join Date: Mar 2002 Posts: 1	Can anyone tell me how? Passed a copy of s sheet to a client who, rather than making changes in a single column, changed things everywhere with no revision tracking at all.

Mar 14th, 2002, 01:14 PM	#2
tk19 New Member Join Date: Mar 2002 Posts: 33	one idea is to put the two sheets next to each other in the same workbook (renaming one of them). For example, if one is named "MyVersion" and the other "ClientVersion" then add a new sheet, and in the new sheet's cell A1, put: if(MyVersion!A1<>ClientVersion!A1,"*","") then "*" will show up if they're different.