Search results

Hi Narayan I have been playing about with the Macro with my limited knowledge, and have got it working. I was just wondering if there is a way to alter it to make the light go around the cells in a non uniformed pattern. Like jumping from say cell 1 to cell 28 to cell 126 and then cell 45 and...

Hi Narayank991 Thanks for that if you have not finished it there is no hurry I will not need it until next week so if you want to finish it tomorrow thats fine. Many Thanks Mike

Narayank991 My sincere apologies in my previous post I referred to you as Narayank911 a slip of the typing finger sorry. Anyway I was saying in that post that you had the idea of what I want to do. And that is have the 250 members names in the 250 cells and have a flashing light go through all...

Good morning Gentlemen I think I have probably not explained correctly what I want to do. I have 250 cells with a different name in each one which are the members. All I want to do is have a flashing light go from cell to cell and stop after 3secs and then resume with another selection I think...

Hi Hui Thanks for your quick reply but I do not fully understand.I have filled out 250 cells with members and that is from A1-J25 and have took note of A1 which in this case is 44. Do I put =Randbetween(1, 250) in cell K1? and put the format =A1=$K$1 in all 250 cells.And please excuse my...

Hi All I would like to create a sheet were you can get the cells to light up and stop on a number after say 3secs or 5secs so the light flashes across all the cells and then stops and then you restart it to get the another number. These numbers are members so there are 250 members so there will...

Hi ranaray I do not understand you have posted WHAT? and what codes conflict? Mike

Hi There Key Master Please do not feel embarrassed. The incident is forgotten as far as I am concerned. bobhc is right I should have continued on my original post and then this misunderstanding would never have arisen. But hey we are all humans and we all make mistakes. Anyway may I wish you a...

Hi Key master I have just logged in on the Forum and I am somewhat perplexed by your answer to me regarding my post to Luke. I am never discourteous or rude to anyone on this Forum as I am sure the many people I have dealt with will verify. The post we are talking about concerns a Macro that I...

Hi There Luke M Just to inform you I will not be able to post the Macro I have used Because it does not work. When I went into it a day later all the dates had updated to that day's date (22/9/12) and today it has updated again to (23/9/12) So it does not fit the purpose and anyway I do not...

Hi There SirJB7 and kaushik03 Thank you for all your help and time but I have resolved the problem with a macro and it has done exactly what I wanted it to so everything is now up to date. Once again thank you for time and patience. Have a great day and a brilliant life Mike

Hi kaushik03 That is right 79. player(7) player(9) =COUNTIF($F$2:$F$550,79).So when I enter the details it needs to look like this F>>>>>>>G>>>>>>>H Player>>Times>>>Date...

Hi SirJB7 I must apologise for taking so long to answer but I have been in a stupid meeting that lasted forever. Anyway just to verify things player(1) and player(2) are entered in the formula as (12)=COUNTIF($F$2:$F$550,12) And (79) is Player(7) and player(9)and (35) is player(3)and player(5)...

Hi kaushik03 Yes your right I have a list of dates and I want excel to sort them into their respective orders because in future when I list down the pairings in the spreadsheet I want it to include the date. For example player(1)& player(2) which is (12) in the formula last played together on...

Hi There kaushik03 I think maybe you may have misunderstood as I explained first off 12 in the formula is actually Player(1) and Player(2). But it is entered as (12) and the next one is (37) which is actually player(3) and player(7). And player(10) and player(11) is entered 1011 and it all...

Hi There It is me again. I would like a bit of help on including a date in my formula.I work out the pairings for our golf club. I have sorted out the formula for doing that with all the help from all you kind people in the past.=COUNTIF($F$2:$F$550,12) but what i want to do is include the...

Hi there vijaySharma Many thanks for that info I have done what you said and sure enough it has righted itself can now save straight to that folder Once again many thanks Mike

bobhc I have done that and it has saved it in the normal folder.Thanks a million have a good day and a brilliant life Mike

bobhc Well i made another folder on the desktop and saved it to there and lo and behold it works I cannot believe why it would save in another folder rather than the one i save all my xcel files to Windows 7 ???. Anyway thanks for all your help at least I have got it saved. If you want some...

bobhc There are no buttons when I Boot up it goes straight onto the desktop. But I right click on the programme and select run as administrator but that does not make any difference Mike

Hi there bobhc Well from the information I have received Windows 8 is not very good and I think this is reflected in the price of the update £49:99. But anyway my Windows 7 has been running perfectly I have checked all the details on the security tag and it says I have total control but I have...

Hi There SirJB7 nice to hear from you again regards to this problem no it is not saved to a network or clouded files it just keeps coming up with (you do not have permission to save at this location contact your administrator) which of course is me if I can't sort it out I think I will revert...

Hi Luke No I have just created the file and when I finished it ask me to save or don't save and obviously I clicked save but then this message comes up (File Golf Pairs You do not have permission to save in this location contact your admistrator.) Well I am somewhat perplexed as I am the...

I wonder if some one can help me out here I have done an array table in Excel and clicked on Save but it has come back you do not have permission to save. Contact your administrator. I am the Administrator I own the PC whats all this about I have never had this before. Mind you it is Windows 7

Hi Jai9 Thank you very much that works a treat and also all you other guys Busymanjohn and my old friend NARAYANK991 much appreciated all have a great day and a brilliant life Mike