Hello m m Is this the kind of thing you where after? You need to run the 'AllSheets' Macro. Still a couple of bits needed to tidy up, for exampl...
Nothing attached so it is difficult to answer the question without seeing the layout and formulas, but i would say that you will need to copy> past...
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 testin...
Hundreds of sheets in a workbook is some going, I usually tell people to stop at 20. So you want to sum A5 in every sheet where the date in B2 is bet...
No problems, but be careful with it - its not a perfect fix
It cant go in the Last Name column as that is the columns with the starting data. I put it at the end.
Doesn’t seem to be a great deal to work off I can’t see a way to assign Mr/Mrs/Miss etc as its not in the data as we don’t even know the sex of the...
Hi Michelle Could you add a smallish sample workbook so we dont have to recreate the problem? Purfleet
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
Hi Shane Good spot on the remove dups part - I uploaded an older version of the worksheet with that line missing. I have now added that part and also...
Morning Shane I thought we should start again - for 2 reasons - 1) i cant remember anything we did/spoke about before 2) I cant be bothered to read...
you only need to post an example, mix up names and numbers? Purfleet
Thought about this last night and thought i would have a look over the long weekend whilst in lockdown. Work has been fairly busy over the last week o...
Somthing like the below? Sub LenRowHeight() Dim r As Range Dim c As Variant Set r = Range("a:a") For Each c In r If Len(c) > 10 Then c....
Can you please add an example workbook so we do not have to recreate the data? Purfleet