Hello everyone,
I am new to the forum and also to the Excel/VBA environment, and I need your help if possible.
I'm currently working on a project but I don't know where to start lol, I'll explain the problem:
I have two Excel files: version1 and version2 I would like to make the comparison between some columns.
In version 1 I have two columns A and B
column A = ''users'' and column B = ''features'' (these features are used by users)
Each user can use one or more "features".
In version2 (which is a refresh of version1)
We have the same columns but there is a small change Users may not have the same features as version 1, they can add or remove features.
the goal is to create two more columns: column C = fonctionnalités_ajoutées and column D = fonctionnalité_supprimées.
Is there a code that can detect for each user if he has added new features or if he has removed old features and after this comparison it displays us in the two new columns either the features add for this user or the features remove for the same user.
Thank you very much, if you have any questions don't hesitate ;-)
Hello
Yes, it's possible:)
Is it possible to have a sample file?
Yes I have two excel files where I do the test, you find test1 and test1_v2 as you will notice comm1 in the test1 file has changed features in the file tset1_v2 it has added and removed features. If you can help me I would be grateful thank you in advance.
test1.xlsx
Can I add a column to the test1 file?
yes of course, go :D
For more simplicity to work, I put the 2 files on 2 tabs of the test1 file.
It's complicated to display deleted on page 2, so I display it on page 1. Is that okay? Otherwise, I have no other solution than to make a macro! Unless someone else knows a solution and in which case I'm interested!
Edit: with the attachment
test1.xlsx
Hello
Lynkoa's vocation is to deal with CAD even if we can sometimes use excel or other solutions but I don't have the impression that this is your case.
Please use dedicated excel forums for this kind of question.
Kind regards
thank you .pl, but ect can you explain to me how it works because I can't make it work I try a test to see but without result,
Hello
Me to check the difference between 2 excel I go here.
http://www.xlcomparator.net/
may the force be with you.
As I said, I only used one file, number 1, but on 2 tabs. So the number 2 is not used. When we add information on page 1 or 2 we have the results directly.