Blood Bowl Tournament tracker

Hi all!

I have a few problems with text aligning and functions in excel. What I'm trying to create is a form that will automatically copy text strings from one cell to another.

What I need the file to do is to take the team name and copy it into another cell and aligning it so that it's read vertical. I can't seem to find an easy way to do it.

I appreciate your help,

//Jonatan

No, it's a crossreference sheet, which means that the name of the team should appear as the first post in both a row and a column, but to decrease the width of the columns, the name needs to be vertical.

Problem solved!

I have another similar problem though.

The method I used was to write an =sign and then clicking the target cells. I now need that same formula, but referring to another worksheet, but I can't get it to work.

Originally Posted by Dave Peterson

Just format the cells (format|cells|alignment tab)???

Dave Peterson

Yes, I solved that one, but the reference to another worksheet I can't get to work, any ideas..?

Originally Posted by Dave Peterson

Formulas can't return this kind of formatting.

You'll either have to do it some other way.

Copy|paste special|formats
format|cells|alignment tab

You could use a macro that does the work, but that still won't be a formula.

Dave Peterson

I got it to work by just setting the cells format and then setting a function to copy the text from another cell.



I have another question for my Tournament Tracker document.

I have created a worksheet where the user can see different data about the teams involved. All data are referrals to another worksheet and I've created a few simple macros so that the users can sort the table in the way he likes.

Now I need to protect the worksheet from unintended changes, but I still want the user to be able to sort the table using the buttons I've inserted. I can't seem to get it to work properly though.

Excel gives me an error message that tells me that "Error '1004' the object you're trying to change is protected" (or something like that since I'm working with a swedish version). When I protected the worksheet I selected the boxes that indicates that any user may sort the data.

Any suggestions?