Hello, I am trying to compare columns on three different tabs. The three columns (each on a different tab) could contain similarly named items, so I need your macro to consider near matches. You could even add a column to show the accuracy %. Once a match is identified, display like what is shown on the Desired Output tab. I want this to be modular where I can edit which tabs and columns are shown on the output tab:
*// Example of how I can change the output columns in the macro:
If there is an approximate match for the Account columns on any of the tabs, display:
- Tab 1 Account Name
- Tab 2 Account Name
- Tab 3 Account Name
- ["Group 1","Account"]
- ["Group 1", "Month"]
- ["Group 2, "Month"]
-["Group 3, "Example Column name"]
etc (Whatever I want to enter)
- I would like this deliverable to work in Excel Office 365 ProPlus
- It needs to handle tabs with as much as 100,000 rows each
- Please be sure to start the message in your bid with the words "Dear Douglas" so that I know you have read directions carefully
- Please end your bid in the number one. For example, instead of bidding ten dollars, bid eleven instead. This will further prove to me that you can read and understand directions carefully
Let me know if you have any questions!
42 freelancere byder i gennemsnit $123 på dette job
Hi I have recently done same job in which it compares the name and give percentage to you.I can also build you same kind of macro that can show the similarity in percentage.
Dear Douglas Hello I have much experience in Excel MACRO development. I can start from now on and will deliver quality work asap. Lets discuss more detail via Chat. Hope to hear from you soon. Best Regards.
Hope you are doing great. I can help you in this project. Please send me a message to discuss more. I am available to start working on the project immediately