Recent content by Jo4x4

Hi Hui, thanks again for your assistance! You have mail... Jo

Hi Hui, don't worry about it. I simply put a "fake" team at the top, and then it works fine. Thanks again Jo

Hi Hui, Thanks for all your help. It works great, except when there is not yet a team in. From the second team it works, but if you clear the values, it then tries to put the first team name at the bottom of the sheet. Thanks Jo

Hi Hui, Sorry to be a pain... Can you help please? Thanks Jo

Hi Hui, I need your help again if you can. I have uploaded a sample here: http://rapidshare.com/files/440880304/sample.xlsx On the Electronic score sheet, I will add a list so that the operator can just choose the team, and the driver and nav name will pop up. That is not the problem...

Thanks Hui, you are the man! Sorry Ninja :) Jo

Hi Hui, No, I am way too stupid for this... You helped me with a VLOOKUP that changes my "master sheet" with information stored elsewhere in the workbook. A button then saves this new information as a new sheet, and renames it. That is where my problem is with your print settings. I don't...

Hi everybody. Hope you had a wonderful festive season. Can somebody please help with some code to copy print settings as well? Thanks Jo

Hi, I have a sheet with a button on that I use to copy the sheet with a different name in the same workbook. However, the copy doesn't have the same print setup as the original. I know I can press ctrl and save page setup, but this is slow, as there are many copies. Also, someone might forget...

Brilliant stuff! Thanks a stack! Jo

Hi, I have a sheet with a few teams and their scores. I would like to create a separate sheet with each teams scores. They all need to be in the same workbook. I have played around with some coding I got off the net. I managed to get the tab(sheet) renamed to one of the cell blocks. I also...

Hi Dan, Great! Yes, that is exactly what I was trying to do. I just need the score sheet separate, but I should be able to move them. Thanks a stack to you and Hui for your assistance. I don't know where you guys are from, but when next you are in South Africa, I owe you a beer! Cheers Jo

Hi Hui, No, the teams are not repeated on the master sheet. I need different sheets for a specific team: ie. A team sheet with all their information, then a scoring sheet with some of the information (separate for each team). Score sheet 1 will be for team 1, score sheet 2 for team 2...

Hi, I have uploaded a sample file here: http://rapidshare.com/files/434978424/test.xls As you will see, I need some of the information on specific sheets. And there are a lot of them! Ideally, I would like to just type the team number, and then get the relevant fields. I appreciate the time and...

Thanks Hui, will try that now...