Search results

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...

Hi Dan, Excel explosion delivered the exact results I wanted, with one problem: The Output files are not linked to the original, so any changes will have to be manually updated. Thanks anyway for your assistance. BTW, it is now 6:45am Sunday morning in sunny South Africa! Jo

BTW, I am on 2003...

Thanks guys, But I need every row in a separate sheet, so dragging it down won't help. Or am I missing something? As I said, it still helps me a lot anyway. Thanks Jo

Hi Hui, Thank you for your prompt reply. It already helps, but it seems that I would have to replace the "A2" in =if(mastersheet!$A2=$A$1,MASTERSHEET!A2,"") with "A3" and so on? Is this correct? It is still a lot less than copying and linking, but I just want to be sure that I understood it...

Hi, I have a master sheet with various columns ie. Team number, Driver, Navigator, Vehicle, Registration number etc. Under each of these there are lots of rows (Teams). I want to split this master sheet up into different sheets (One for each Team) containing only the information for that...