Prev: Error in Workbook_Open
Next: get the name of the currently active procedure?
From: Del on 17 Jul 2008 16:05
I've got some experience with VBA in Access but I am new to Excel VBA. My
customer provides me with large spreadsheets for each revision of a product I
build for them. They frequently make minor changes to one or two of the
records which places me in the position of comparing line for line, cell for
cell to find the changes. It takes hours and it will not work to have my
customer flag the changes for me. So, I'd like to put some code together
that will compare the data between revisions. In Access I'd use a StrComp
Function. Is there a similar function in Excel that I could use?

I have tried to import the spreadsheets into Access to do the compare but
ran into difficulty keeping the records in the same order until I could tag
them with unique IDs. Keeping the records in the same order during the
transfer was eccential.

Thanks for you help,
--
Thank you,
Del
From: Joel on 17 Jul 2008 17:50
There is "Compare and Maerge Workbooks" in the excel Tools Menu.

"Del" wrote:

> I've got some experience with VBA in Access but I am new to Excel VBA. My
> customer provides me with large spreadsheets for each revision of a product I
> build for them. They frequently make minor changes to one or two of the
> records which places me in the position of comparing line for line, cell for
> cell to find the changes. It takes hours and it will not work to have my
> customer flag the changes for me. So, I'd like to put some code together
> that will compare the data between revisions. In Access I'd use a StrComp
> Function. Is there a similar function in Excel that I could use?
>
> I have tried to import the spreadsheets into Access to do the compare but
> ran into difficulty keeping the records in the same order until I could tag
> them with unique IDs. Keeping the records in the same order during the
> transfer was eccential.
>
> Thanks for you help,
> --
> Thank you,
> Del
 | 
Pages: 1
Prev: Error in Workbook_Open
Next: get the name of the currently active procedure?