Hi all,
I need some help. I need a quick VBA scripted IF statement (macro) that compares 2 cells within the same row (in this SAMPLE cells A and B) in sheet 1.
If the cells are equal then the ENTIRE row needs to be copied and pasted onto sheet 2.
If they are not equal then the ENTIRE row needs to be copied TWICE onto sheet 2 and this needs to loop until it has gone through all lines.
Sample attached. thanks in advance!
Hi ivector
Try this Code
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
John,
this code works for the sample I provided beautifuly. if I wanted to apply it to another sheet with columns other than "A" or "B", what variables would I have to change in the code to make it work?
Hi ivector
That depends...are the Columns that are being compared adjacent?
yes they are
Hi ivector
What are the comparable Columns; in your Sample Data they were "A" and "B".
the columns would be named "Qty" and "Qty adjusted" respectively or would generally fall under columns "R" and "S"
Hi ivector
You sayDoes that infer they could be "Somewhere else"?would generally fall under columns "R" and "S"
If yes, then the Code will need to find them. This can be done but you'll need to provide a new Workbook that has the SAME Structure as your Actual File...proprietary information sanitized.
One further point of caution, if either of the Worksheets has Headers the Code will not perform as expected.
So, it'll behoove you to attach a File that truly represents the Structure of what you have.
On the other hand, if neither Worksheet has Headers AND Columns will ALWAYS be "R" and "S" you need change only one Line of Code (I think).
Change this Line fromToPlease Login or Register to view this content.Please Login or Register to view this content.
Last edited by jaslake; 12-05-2014 at 05:22 PM.
Thank you very much for your help Jaslake! works like a charm. Cheers!
-Vector
You're welcome...glad I could help.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
done......
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks