Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF and Lookup functions
I have a database which gets sent to clients and they make changes save
it as a seperate workbook and it gets sent back and not necessarily in the same order as it was sent What i want to be able to do is make a comparison by looking up the unique id for each record and seeing what fields have been changed Not sure if VBA is the best way to sort this out but i have about 40 of these databases that get sent out with the same amount of responses and to sit and read through each one to see where the changes are a nightmare Any Suggestions? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF and Lookup functions
VBA is certainly the best option I can think of.
Assuming records are not added, a simple sort of the table on the unique ID should put the records in the same order. there are many ways to approach this and it would really require knowledge of what you have and what you want to do. The brute force method would be to either loop through the master or to loop through the revised database and compare between the two, identify the differences and then do what? Another apporach would be to consolidate all the data into one workbook with each set of data marked on each record as to the source. then you can do sorts and comparisons with your code all at once. Not sure what you expect to get out of your post. But, given no specific information, your general description would say that VBA is a manageable way of doing this. Of course if you are not experienced with VBA, then it might not be the best way. -- Regards, Tom Ogilvy "tarynnl" wrote in message ... I have a database which gets sent to clients and they make changes save it as a seperate workbook and it gets sent back and not necessarily in the same order as it was sent What i want to be able to do is make a comparison by looking up the unique id for each record and seeing what fields have been changed Not sure if VBA is the best way to sort this out but i have about 40 of these databases that get sent out with the same amount of responses and to sit and read through each one to see where the changes are a nightmare Any Suggestions? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF and Lookup functions
Just some thoughts...
Another way is to track the changes as they happen. For example, the following code in the worksheet code window will enter "Changed" in column A in the row that changes. '*** Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Cells(Target.Row, "A").Value = "Changed" Application.EnableEvents = True End Sub '*** Of course the above code only works on single-cell input, I just want to give you the idea. A variant method is to build a UserForm interface, but then things are getting more complex (but safer), so it depends on your VBA experience. HTH Anders Silvén "Tom Ogilvy" skrev i meddelandet ... VBA is certainly the best option I can think of. Assuming records are not added, a simple sort of the table on the unique ID should put the records in the same order. there are many ways to approach this and it would really require knowledge of what you have and what you want to do. The brute force method would be to either loop through the master or to loop through the revised database and compare between the two, identify the differences and then do what? Another apporach would be to consolidate all the data into one workbook with each set of data marked on each record as to the source. then you can do sorts and comparisons with your code all at once. Not sure what you expect to get out of your post. But, given no specific information, your general description would say that VBA is a manageable way of doing this. Of course if you are not experienced with VBA, then it might not be the best way. -- Regards, Tom Ogilvy "tarynnl" wrote in message ... I have a database which gets sent to clients and they make changes save it as a seperate workbook and it gets sent back and not necessarily in the same order as it was sent What i want to be able to do is make a comparison by looking up the unique id for each record and seeing what fields have been changed Not sure if VBA is the best way to sort this out but i have about 40 of these databases that get sent out with the same amount of responses and to sit and read through each one to see where the changes are a nightmare Any Suggestions? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup functions | Excel Worksheet Functions | |||
lookup functions | Excel Discussion (Misc queries) | |||
Lookup and IF functions I think?? Need Help!!!! | Excel Discussion (Misc queries) | |||
If ,AND, LOOKUP, Functions | Excel Worksheet Functions | |||
help on lookup functions | Excel Worksheet Functions |