Search results

Thanks for that bobhc but that was not the one because that did not work it kept giving me Jan 00 1900 so hopefully Narayank991 might recall it Many Thanks

Hi Everyone I had a formula provided to me very kindly by Narayank911 about a year ago and I am afraid it has disappeared from the computer. It was one that allowed me to print the date on my master copy and it would print it at the same time opposite the Members number i.e Master Copy...

Hi oldchippy Many thanks for that. That is just perfect thanks for your time and trouble Have a good day and more importantly have a brilliant life Mike

Hi oldchippy Many thanks for that but I am using Letters "E","L","P" so when I enter the letter I want the cell to change to the colour "E" blue, "L" red, "P" green will thatwork with this formula? Mike

Good day Everyone. I would like to be able to change cell colours so that when certain letters are entered the cell changes to the appropriate colour. They will be connected with the weekly sales so the letters entered will be P=profit,L=loss,E=even.so the formula will look something like this...

I must apologise for the delay in replying but un fortunately my PC crashed and now the problem is solved. Apparently it was the mother board that gave up the ghost so had a new on fitted problem solved. Thank you for your replies. Mike

Hi I was wondering if anyone could give me some help with my Excel 2010. I realise this is not the usual request on this board but I am a bit stuck. Excel takes ages and ages to open up approx 5 mins I have tried a lot of things but to no avail I was wondering if anyone else has come across this...

Hi Luke I have given him that and told him if he figures out how to select the correct numbers a big donation from him would not go amiss. Don't hold your breath I think we would have a better chance of flying to Mars and back than he has of picking the right numbers. Mike

Hi Narayan Thanks for that I will pass it on to him. But that is it now we will go no further with it I have told him this will be the final one there will be no more so if he cannot get it to work tough. Anyway Many Thanks Narayan for your time and patience Mike

Hi Narayan Thanks for that I will give it to him and he can see how he gets on. I have wasted enough time with this (And you more so.) I have told him it is to complicated and takes up an awful lot of time and a horrendous amount of cells but that is upto him. Once again many thanks for your...

Hi Luke I have told my friend it will take to long to do and the space taken on his computer will be horrendous 13983816 cells and it will take him weeks to sift through them. But he has some theory that there is a pattern of how the numbers come out which I replied there are far cleverer...

Hi Narayan Sure that is no problem I am in no hurry he can wait until its done Many Thanks Mike

Hi Narayan I have just been talking to him. Yes you are right he does not want the sum of 6 numbers he wants all the possible combinations of 1 to 49,in 6 number selections i.e 1,2,3,4,5,6, 1,2,3,4,5,7 1,2,3,4,5,8 etc,etc.Until you end up with 44,45,46,47,48,49. But if it cannot be done don't...

Hi Narayan Yes I have messed it up somehow I probably should not have put that I wanted to tell it to give me all combinations of 1-49. So do I put it like ("combos",1-49) will that give me them. Mike

Hi Narayan Ok thats fine no hurry Many Thanks Mike

Hi Narayan Its me again. My friend who runs a Lottery Syndicate asked me it I could give him a formula or a macro to give him all the possible combinations of the numbers from 1-49 which as you are aware runs into millions (13983816 to be precise) what he is going to do with it I have no idea...

Hi Narayan Brilliant just how I want it now,its a good job I can rely on you to get me out of the mire, still I tried. Once again my sincere Thanks for your time and help. May you have a good day and a brilliant life. Many Thanks Mike

Hi Narayan Thanks for looking at that I thought it would be me messing it up I am pretty good at that. Anyway if it is a lot of bother do not put yourself out I will resort back to the 2 columns, but if you can do it, it would be very much appreciated. I tend to get backache very much sat down...

Hi Narayan Sorry to be a menace. But I decided it would be better if I had 5 columns to record the numbers in so I increased the columns in the macro I then got various messages such as Else without If Loop without Do and the last one is Block If without End if, I am afraid I have not got a...

Hi Narayan Fabulous just perfect this will eliminate the use of the (dozy secretary). Once again you come to the rescue my many thanks to you and of course Luke M. May you both have a good day and a brilliant life. Many Thanks Mike

Hi Luke Thanks for that just one little problem it lists all the numbers in one column (F). I would like it to give first number in F scond number in G third number in F fourth number in G and so on if that cannot be done no big deal i will have to seperate them manually Many Thanks Mike

Hi Narayan Thanks for that here is the macro you created for me Public Sub Circular_Lights() Const HIGHLIGHT = vbBlack ' Change as required Dim Number_of_Rows As Long Dim Number_of_Columns As Long Dim Row_Selection As Long Dim Col_Selection As Long Dim Start_Time As Date Dim Curr_Time...

Hi Guys Remember you helped me out with the Macro for selecting numbers for our golf club pairings, well it works brilliantely, but while I am in the office at the computer the Secretary is in the bar watching the draw and was supposed to take down the numbers,But he didn't he said he was...

Hi Narayan That is absolutely brilliant it works just as I had hoped it would. The members sat in the bar were all well impressed to be able to see the actual draw being made and shown on a big 50inch TV and low and behold there were no moans or groans because they could see the draw was all...

Hi Narayan Thanks for that no hurry. Mike