Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default displaying text in a cell if a another cell falls in a range

Excel 2003
I have a cell that has formated text (Bold, italic, and indented) in it. I
would like to build a printable "Microsoft Word like" letter from the result
of a testing spreadsheet I have made. The problem that I am having besides
getting the text to show up formatted, is that I would then like to have it
print in numerical order of the score within several (10) different
areas.....ie...

Treatment Plan
--------------------------------------------------------------------------------------------
1. Problem Sovling
Specifying Goals
Goals
*Increase goal setting abilities
Interventions
*Assist the client in specifying realistic short and ling term
goals
Defining problems and causes
Goals
*Increase problem solving abilities
Interventions
*Assist the client in defining problems and causes of problems
----------------------------------------------------------------------------------------------
2. Communication
Communicating ideas clearly
Goals

and on and on.....so and so

Each area of data has a range....and if the range is low the client needs to
work on that area. I would like the treatment plan to "build" itself based on
their scores in each area they are weak in, without printing the whole
treatment plan.

I know this is a long question, but I tried to get an answer before and I
only received half answers, no real results. I would be more than happy to
send the whole program to someone to look at, if it would be easier. Thank
you advance for your assistance.

Scott
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,441
Default displaying text in a cell if a another cell falls in a range

Scott,

Excel is not a word processer, and formatted text cannot be returned by a formula.

The best approach is to use a macro to copy and paste the cells that contain the formatted data that
you need in the order that you need, making adjustments as required to match your requirements (like
numbering, etc.).

It will not be a very complicated system, but you would be better off finding someone to do it for
pay, since it will take a bit of effort to complete, certainly beyond the scope of a few posts here.

HTH,
Bernie
MS Excel MVP


"THIRDCOAST" wrote in message
...
Excel 2003
I have a cell that has formated text (Bold, italic, and indented) in it. I
would like to build a printable "Microsoft Word like" letter from the result
of a testing spreadsheet I have made. The problem that I am having besides
getting the text to show up formatted, is that I would then like to have it
print in numerical order of the score within several (10) different
areas.....ie...

Treatment Plan
--------------------------------------------------------------------------------------------
1. Problem Sovling
Specifying Goals
Goals
*Increase goal setting abilities
Interventions
*Assist the client in specifying realistic short and ling term
goals
Defining problems and causes
Goals
*Increase problem solving abilities
Interventions
*Assist the client in defining problems and causes of problems
----------------------------------------------------------------------------------------------
2. Communication
Communicating ideas clearly
Goals

and on and on.....so and so

Each area of data has a range....and if the range is low the client needs to
work on that area. I would like the treatment plan to "build" itself based on
their scores in each area they are weak in, without printing the whole
treatment plan.

I know this is a long question, but I tried to get an answer before and I
only received half answers, no real results. I would be more than happy to
send the whole program to someone to look at, if it would be easier. Thank
you advance for your assistance.

Scott



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default displaying text in a cell if a another cell falls in a range

Thanks Bernie MVP

"Bernie Deitrick" wrote:

Scott,

Excel is not a word processer, and formatted text cannot be returned by a formula.

The best approach is to use a macro to copy and paste the cells that contain the formatted data that
you need in the order that you need, making adjustments as required to match your requirements (like
numbering, etc.).

It will not be a very complicated system, but you would be better off finding someone to do it for
pay, since it will take a bit of effort to complete, certainly beyond the scope of a few posts here.

HTH,
Bernie
MS Excel MVP


"THIRDCOAST" wrote in message
...
Excel 2003
I have a cell that has formated text (Bold, italic, and indented) in it. I
would like to build a printable "Microsoft Word like" letter from the result
of a testing spreadsheet I have made. The problem that I am having besides
getting the text to show up formatted, is that I would then like to have it
print in numerical order of the score within several (10) different
areas.....ie...

Treatment Plan
--------------------------------------------------------------------------------------------
1. Problem Sovling
Specifying Goals
Goals
*Increase goal setting abilities
Interventions
*Assist the client in specifying realistic short and ling term
goals
Defining problems and causes
Goals
*Increase problem solving abilities
Interventions
*Assist the client in defining problems and causes of problems
----------------------------------------------------------------------------------------------
2. Communication
Communicating ideas clearly
Goals

and on and on.....so and so

Each area of data has a range....and if the range is low the client needs to
work on that area. I would like the treatment plan to "build" itself based on
their scores in each area they are weak in, without printing the whole
treatment plan.

I know this is a long question, but I tried to get an answer before and I
only received half answers, no real results. I would be more than happy to
send the whole program to someone to look at, if it would be easier. Thank
you advance for your assistance.

Scott




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF CELL VALUE FALLS WITHIN A RANGE OF VALUES Melvin Tang Excel Worksheet Functions 8 September 4th 07 04:59 AM
selecting multiple cell in a roll that falls withing a range Olamide Charts and Charting in Excel 1 March 15th 07 02:43 PM
Displaying cell range with Vlookup Danhalawi Excel Discussion (Misc queries) 2 November 9th 06 04:28 PM
cell text not displaying into next blank cell MatthewS Excel Discussion (Misc queries) 3 August 31st 06 06:29 PM
update cell only if now() falls in a given date range treyn1292 Excel Worksheet Functions 0 February 16th 06 09:54 PM


All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"