Trusted Members
December 20, 2019
Morning Shane
I have added Safe Bets lay v FA Lays 2 - can you please check.
If all okay, what is the next comparison?
Purfleet
March 3, 2020
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 copied across perfectly and quickly
That is Safe Bets Lays vs FA Lays 1 and Safe Bets Lays vs FA Lays 2 done. The final comparison is FA Lays 1 vs FA Lays 2 and it will be complete
Thanks so much for all your help with this one. I can't wait to experiment with trying to do it in reverse, with only the other 7 sheets compared.
cheers
Trusted Members
December 20, 2019
Hello mate
I have added ShaneX_falay1_v_faLay2() - there was 280 rows copied this time. Sound about right?
You will obviously need to do some testing and try your best to break it.
I hope it is what you were after and let me know how you get on
Purfleet
March 3, 2020
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 guess the last thing which needs to be done is to have the 3 parts all incorporated in the one thing. You've done FA Lays 1 vs Safe Bets Lays, FA Lays 2 vs Safe Bets Lays and FA Lays 1 vs FA Lays 2 and each worked perfectly in isolation; now to see them all work as a whole.
Stay safe mate
Trusted Members
December 20, 2019
HI Shane
There was a sub in the last file (New Results File_Full_PurfleetX5.xlsb) called ShaneXRun which has all the subs needed to run the lot in one go
Sub ShaneXRun()
Call ShaneX_Setup
Call ShaneX_sbLay_v_faLay1
Call ShaneX_sbLay_v_faLay2
Call ShaneX_falay1_v_faLay2
Call ShaneX_Cleanup
End Sub
Have you tried that one?
Purfleet
1 Guest(s)