Hello,
I have an excel sheets with 10 columns the first 7 columns are one group and the other 3 columns are second group. I'm trying to compare the 2 groups and align duplicates in same line based on cells in (A) and cells in (H).
So if Cell A1 = H3 align A1-G1 with H1-J1 and so on. Any example code please?
On this page are numerous "Line Up Matches" puzzles and VBA solutions. The one you would most likely use and adapt is Problem #4.
Line-up-matches
Last edited by JBeaucaire; 12-26-2019 at 03:44 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I tried before this concept and edited the code so it compares A with H however it didn't work.
When run the marco I asked it to compare G with H for simplicity however the ending result is wrong. It clears certain cells and aligns wrong duplicates.
Please Login or Register to view this content.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Thank you for your reply. I've attached a sample workbook with dummy data with the code in it.
What I'm looking for exactly compare G to H let's say if G1 = H79 then align A1:G1 with H79:J79 since both are 2 groups and should have the relative data the outcome will become A1:J1 = A1:G1 + H79:J79.
Thank you for your support
Try
Edit: Fixed a bugPlease Login or Register to view this content.
Last edited by jindon; 10-29-2017 at 11:47 AM.
Thank you, you saved my day. As I can see the results are parsed in a new sheet.
Last edited by webiscore; 10-29-2017 at 12:08 PM. Reason: Removing Quote
You are welcome.
1)
Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding
For normal conversational replies, try using the QUICK REPLY box below.
2)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks