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

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

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

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

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

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

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

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

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

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

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