Forum Discussion
How to validate multiple columns from a single duplicate column in 2 worksheets
Is it possible to upload the actual spreadsheets (after taking out any confidential information, or modifying it so as to be anonymous).... images don't really convey the full reality.
And let us know if there are going to be not just duplicates in each (external and internal) sheet, but are there going to be multiple instances of those duplicates in some or many cases? This could be a simple situation, or it could be more complex, depending on things like that.
So a more compete description would be helpful, but at the very least a good representation of the actual spreadsheets involved.
mathetes I have attached a small example sheet with random info to see if that helps?
Its just understanding the step by step as every time I try something I just get errors, so I must be doing something wrong or missing something out. Many thanks for your response.
Unless I'm missing something, the sample you sent has no Order Ref No's that match. So it's kind of difficult to create a test case. Now, I could obviously modify one or two so there is a match, but I have other questions anyway. So could I ask you to answer them and give a revised sample where the fundamental conditions are met in one or two cases, i.e., where there are matches between one or two Order Refs.
Once you find a match, you said you want the data in the green on the "Internal" sheet brought over to the "External"--that's easy enough to do when there's a match [see above], and we'd have to create columns for that, easy enough...
FINALLY, you make reference to a "Final Validation Sheet"--where is that? Is it just the to-be-updated External sheet, including your comments in the red columns? Or some other sheet altogether.
mathetes ok I will try explain a bit better. I have added a new sheet with better representation.
Ill explain each highlighted part.
The final sheet needs to be the EXTERNAL sheet.
Yellow - Find the duplicates from INTERNAL & EXTERNAL in these columns.
Green - These values also need pulling across with the web order number into EXTERNAL.
Red - Once the information from INTERNAL has been moved to EXTERNAL these are the columns I will then be able to fill in and use this sheet as the final validation sheet.
The reason why I need to do it this way around is the columns in the EXTERNAL sheet are important to be included in the final validation.
I hope I have explained it a little better. Many thanks!
