g'day Purfleet Sorry for the delay, I guess we are both busy enough with all the palaver going on. Hopefully things are OK there in the UK. I gu...
That seems spot on Purfleet Just to confirm, I copied all the rows from FA Lays 1 and FA Lays 2 to the Confirmed Lays sheet and did a Remove Duplic...
Hi Purfleet That seems to do the job. Apart from the yellow ones you created, there were only 2 duplicates between those 2 sheets and they are copi...
howdy Have run that a few times and it seems to do exactly what it needs to. The yellow duplicates are copied across perfectly cheers
g'day mate It all seems spot on in theory. It certainly copies that yellow coloured one across because, as you said, there are no duplicates betwee...
ha! You're a marvel mate. So you got back in alright, which is good. Yeah, been busy here as well; just backtesting and trying to develop workable ...
Howdy Purfleet I just thought to check in and see if you were able to successfully get back into the UK alright and everything is going OK; strange...
apologies mate. This one has 7 days on it cheers
hi mate For dupes, the only rows which are of any relevance are A, B & H. One those 3 rows match, you have a duplicate entry. I am relatively s...
Howdy Purfleet What a struggle this has been and is still ongoing. The bottom line is the VBA compares all the sheets and it has proven very diffic...
Thanks for the reply Purfleet. In the end, the only columns really required for a match are A, B & H. If those 3 match, then it is a dupe and thos...
Highlighted just a handful, but there are absolutely loads of them cheers
To make the filter more efficient I thought it was better to leave the header rows in and remove with the remove duplicates That was actually the p...
Hi Thanks so much for your help. Any reason for a binary versus an xlsm file? Do you find it to be more efficient or faster that way? I'd not s...
Howdy Purfleet You're right, I had actually saved the contents of module 1 to a module in the Personal Macro Workbook, then simply created a button...