Blood Bowl Tournament tracker

**JonatanRaven** · 01-12-2006, 09:23 PM

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

Dave Peterson · 01-12-2006, 10:10 PM

You can't do that with formulas.

Formulas only return values to that cell.

Can you just format that other cell, too?

JonatanRaven wrote:
>
> 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
>
>

>
> --
> JonatanRaven
> ------------------------------------------------------------------------
> JonatanRaven's Profile: http://www.excelforum.com/member.php...o&userid=30425
> View this thread: http://www.excelforum.com/showthread...hreadid=500929

--

Dave Peterson

**JonatanRaven** · 01-12-2006, 10:22 PM

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.

Dave Peterson · 01-12-2006, 10:40 PM

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

JonatanRaven wrote:
>
> 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.
>
> Any ideas as how I should do..?
>
> --
> JonatanRaven
> ------------------------------------------------------------------------
> JonatanRaven's Profile: http://www.excelforum.com/member.php...o&userid=30425
> View this thread: http://www.excelforum.com/showthread...hreadid=500929

--

Dave Peterson

**JonatanRaven** · 01-12-2006, 10:45 PM

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

Dave Peterson · 01-13-2006, 10:55 AM

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.

JonatanRaven wrote:
>
> Dave Peterson Wrote:
> > 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..?
>
> --
> JonatanRaven
>
> ------------------------------------------------------------------------
> JonatanRaven's Profile: http://www.excelforum.com/member.php...o&userid=30425
> View this thread: http://www.excelforum.com/showthread...hreadid=500929

--

Dave Peterson

**JonatanRaven** · 01-13-2006, 02:24 PM

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?

Dave Peterson · 01-13-2006, 02:50 PM

Add a couple of lines to your macro:

worksheets("whatever").unprotect password:="hi"
'your code to sort
worksheets("whatever").protect password:="hi"

JonatanRaven wrote:
>
> Dave Peterson Wrote:
> > 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?
>
> --
> JonatanRaven
>
> ------------------------------------------------------------------------
> JonatanRaven's Profile: http://www.excelforum.com/member.php...o&userid=30425
> View this thread: http://www.excelforum.com/showthread...hreadid=500929

--

Dave Peterson

**JonatanRaven** · 01-14-2006, 12:10 AM

Thank you, it worked just fine.

Now to my next problems:

Problem 1:
I'm working on a sheet which will enable me to automatically calculate results and copy the values into the appropriate position.
The sheet looks like this:

\1

I want the data in the cells E10-E12 show the data from J7-J9, E13-E15:M7-M9 et.c.. like this:

\1

I'm using the following formula to do this:
=IF(J7<>"";J7;"")
=IF(J8<>"";J8;"")
=IF(J9<>"";J9;"")
et.c..
this works fine, but it's tedious to do this all over, since I have 18 team entries with 3 rows each.

Any suggestions?

Problem 2:
Now I want the sheet to calculate whether the results indicate a win, loss or tie and also calculate the points awarded, like this:

\1

I don't have a clue how to do this, so any help is appreciated.

This forum has done wonders to my Excel knowledge already!

Thanks!!:

Dave Peterson · 01-14-2006, 08:50 AM

My first suggestion is to post in plain text. Lots of people (me included)
won't open attachments or take the time to view screen images.)

JonatanRaven wrote:
>
> Thank you, it worked just fine.
>
> Now to my next problems:
>
> Problem 1:
> I'm working on a sheet which will enable me to automatically calculate
> results and copy the values into the appropriate position.
> The sheet looks like this:
>
> '[image: http://imgboot.com/images/tankboy122/screencap1.gif]'
> (http://imgboot.com/)
>
> I want the data in the cells E10-E12 show the data from J7-J9,
> E13-E15:M7-M9 et.c.. like this:
>
> '[image: http://imgboot.com/images/tankboy122/screencap2.gif]'
> (http://imgboot.com/)
>
> I'm using the following formula to do this:
> =OM(J7<>"";J7;"")
> =OM(J8<>"";J8;"")
> =OM(J9<>"";J9;"")
> et.c..
> this works fine, but it's tedious to do this all over, since I have 18
> team entries with 3 rows each.
>
> Any suggestions?
>
> Problem 2:
> Now I want the sheet to calculate whether the results indicate a win,
> loss or tie and also calculate the points awarded, like this:
>
> '[image: http://imgboot.com/images/tankboy122/screencap3.gif]'
> (http://imgboot.com/)
>
> I don't have a clue how to do this, so any help is appreciated.
>
> This forum has done wonders to my Excel knowledge already!
>
> Thanks!!:
>
> --
> JonatanRaven
>
> ------------------------------------------------------------------------
> JonatanRaven's Profile: http://www.excelforum.com/member.php...o&userid=30425
> View this thread: http://www.excelforum.com/showthread...hreadid=500929

--

Dave Peterson

Dave Peterson · 01-14-2006, 10:35 AM

My other suggestion is that when you change subjects (the question changes to
something completely different), start a new thread.

Lots of times, people will see the long thread, guess that the original question
was resolved and not bother reading the followups.

Dave Peterson wrote:
>
> My first suggestion is to post in plain text. Lots of people (me included)
> won't open attachments or take the time to view screen images.)
>
> JonatanRaven wrote:
> >
> > Thank you, it worked just fine.
> >
> > Now to my next problems:
> >
> > Problem 1:
> > I'm working on a sheet which will enable me to automatically calculate
> > results and copy the values into the appropriate position.
> > The sheet looks like this:
> >
> > '[image: http://imgboot.com/images/tankboy122/screencap1.gif]'
> > (http://imgboot.com/)
> >
> > I want the data in the cells E10-E12 show the data from J7-J9,
> > E13-E15:M7-M9 et.c.. like this:
> >
> > '[image: http://imgboot.com/images/tankboy122/screencap2.gif]'
> > (http://imgboot.com/)
> >
> > I'm using the following formula to do this:
> > =OM(J7<>"";J7;"")
> > =OM(J8<>"";J8;"")
> > =OM(J9<>"";J9;"")
> > et.c..
> > this works fine, but it's tedious to do this all over, since I have 18
> > team entries with 3 rows each.
> >
> > Any suggestions?
> >
> > Problem 2:
> > Now I want the sheet to calculate whether the results indicate a win,
> > loss or tie and also calculate the points awarded, like this:
> >
> > '[image: http://imgboot.com/images/tankboy122/screencap3.gif]'
> > (http://imgboot.com/)
> >
> > I don't have a clue how to do this, so any help is appreciated.
> >
> > This forum has done wonders to my Excel knowledge already!
> >
> > Thanks!!:
> >
> > --
> > JonatanRaven
> >
> > ------------------------------------------------------------------------
> > JonatanRaven's Profile: http://www.excelforum.com/member.php...o&userid=30425
> > View this thread: http://www.excelforum.com/showthread...hreadid=500929
>
> --
>
> Dave Peterson

--

Dave Peterson