The first sheet represents workbook 1 which would be todays enquiry
The second sheet represents workbook 2 which would have all prior enquires
The third sheet is what I need to end up with after copying the contents of workbook 1 into workboook 2 and removing duplicates based on afore mentiond criteria.
Many thanks for your perseverance.
Last edited by bouncey; 02-11-2010 at 03:13 PM.
Hi,
I don't understand the logic which results in the end product tab. For instance why does order no acs01 from wb1 not appear whereas acs09 appears twice albeit with a different Expd date.
Can you list the logic steps which you take to arrive at the end product mentioning the column data which is relevant to the decision process.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
New wb attached.
Rhe attached shows that although there where 9 new entries today, only one was a true entry, not a duplicate.
The first sheet shows todays enquiries. I want to either cut and paste into the second sheet and then remove duplicates leaving just one unique line, eg if C,E,H are duplicated in two or more rows then I would like to delete the newest entry, but only if there are no buyers comments (column J) if there are buyers comments then all other rows that are duplicated can be deleted.
or
do the removal of duplicates direct from sheet to sheet (no cut and paste).
I feel like I'm losing myself as I type this.
Thanks for your time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks