Just create a sub for each button with simular code then assign each sub to a button Sub Option1() Worksheets("Option 1").Visible = True Workshe...
Hi shane Okay mate, better to start again i thnik. Can you resent the whoole file as is and we can work through it - i think we have the correct...
Something like this should work - needs to be in the main tab module. You can get a bit more creative with the hiding if you have a lot of sheets -...
I think you want the EOMONTH function. Mynda wrote a blog on it a while ago Bascially EOMONTH give you the end of the month, so the last day of Ja...
Can you please supply an example in a worksheet? Purfleet
Hi Valerie We just need 5% of b23 ? so put =B23*C23 in D23 Not sure if you are aware but b17 is not including b8 and if order subtotal and MMB &...
you want to delete blank columns and blank rows? It is much easier if you attach an example workbook to save recreating the data The below shoul...
Can you please add an example worksheet so we do not have to recreate? Purfleet
If the data is sorted you can use =INDEX($A$3:$A$22,MATCH(G3,$E$2:$E$22,1)) Purfleet
Could you be running different versions of Excel i.e 32 bit or 64 bit? I know there are some differences between the 2 versions Purfleet
Probably the most useful piece of code I have learnt. Sub FindLastRow() Dim Lr As Long Lr = Cells(Rows.Count, 1).End(xlUp).Row Debug.Print...
I just recorded a Macro to remove duplicates on one of the older versions we were playing with and it created the following code (i would remove the r...
Okay it makes more sense now. When i said unique I was comparing all columns so all columns must be a duplicate, but your data changes from column P (...
Can you run it and upload the results so i can take a look? Maybe highlight a couple of the dups that you think should be removed Purfleet
Any reason for a binary versus an xlsm file? Do you find it to be more efficient or faster that way? I'd not seen one before. From what i have read...