Docstoc
EXCLUSIVE OFFER FOR DOCSTOC USERS
Try the all-new QuickBooks Online for FREE.  No credit card required.

This Excel spreadsheet

Document Sample
This Excel spreadsheet Powered By Docstoc
					Sheet1




         USE THE COMPARECOL2 MACRO
         IT WORKS FASTER


               Use the COMPARECOL2
               macro (under TOOLS) to
               isolate the values in each
               column that are not in the
                          other.

              For example, to compare GL
                Codes in Plan File to GL
               Codes in Control file, place
              Plan GL Codes in column A
                and Control GL Codes in
                  column B. Invoke the
               macro. When it completes
                 (it may take a couple of
                 minutes) it will return in
                column E those values it
              found in column A but not in
                B, and in column F those
                values found in column B
                       but not in A.




Page 1                                        PBG - 12/4/2011
                                           Sheet3


blah, blah, blah/                                           #VALUE!
blah, blah, blah/                                           #VALUE!
blah, blah, blah/                                           #VALUE!
blah, blah, blah/                                           #VALUE!
blah, blah, blah/                                           #VALUE!
blah, blah, blah/comments: Hello there       Hello there     TRUE
blah, blah, blah/                                           #VALUE!
blah, blah, blah/ Comments: this is cool     this is cool   #VALUE!
blah, blah, blah/ comments: this is cool     this is cool    TRUE




                                           Page 2                     PBG - 12/4/2011

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:12/4/2011
language:English
pages:2