sakura.saki
06-20-2012, 08:36 AM
Hi, now I have a list on sheet1 with not totally empty row and I have to do the following: I have to insert one entire empty row when the team name changes...and it should look like the one on tab "teams CW". I tried to write a piece of code(which is not in the attachment), but it only incerts a lot of rows under the first row.
so is there a method to do so, without the code to find a certain name of a team and insert one row above...because I have like 30 teams later, and it will be a lot of work.
thanks!
so is there a method to do so, without the code to find a certain name of a team and insert one row above...because I have like 30 teams later, and it will be a lot of work.
thanks!