+ Reply to Thread
Results 1 to 5 of 5

adding a large, LARGE amount of text to a spreadsheet

  1. #1
    Registered User
    Join Date
    05-30-2016
    Location
    North Carolina
    MS-Off Ver
    2013
    Posts
    6

    adding a large, LARGE amount of text to a spreadsheet

    Hello everyone,

    I have a question that I am hoping someone can help me with. I work for a department that has massive lists that need to be accessed quickly. The problem is, the creator of the list either is not savvy or didn't have the time to make them into a working and easy to use excel spreadsheet. In an attempt to make life easier, I have been working on this at night to create a more user friendly document that will cut down on errors. So far, I have converted everything into dropdown boxes using the data validation tool, and have tied relevant data to the dropdown box using the VLOOKUP tool. However, I have no run into a snag that I need help with.

    The lists that I am making have a "Scenario" with each line. As an example, the list has a title (ie. "Drilled Well") There is a lengthy scenario that goes along with selecting this title, and I want to show the entire scenario in a block. If the "Drilled Well" practice is selected then this long scenario automatically populates a group of cells.

    So far I have tried to use the VLOOKUP option to populate this by copying the entire scenario and adding it to a cell. This works, however instead of getting multiple paragraphs, I get one very long line that does not fit into my merged cell blocks on the primary page. I am not sure if I am explaining this well, but I really want to know how to make a massive paragraph fit into a merged cell block, using VLOOKUP. Any help is appreciated.

    John

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,448

    Re: adding a large, LARGE amount of text to a spreadsheet

    Hi,

    Is it necessary to have the long text descriptions/paragraphs spread across several cells. If you ensure all the text is in a single cell and with line breaks, i.e. Character 10 wherever you want the text to wrap around, there shouldn't be a problem with a vlookup. Then set the vlookup formula cell to 'Wrap Text. It may also be necessary to have a simple Sheet Change event Macro with a single line of code to set the Row Height to Autofit.

    Avoid merged cell wherever possible. For all sorts of reason that needn't engage us now they are just too much trouble.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: adding a large, LARGE amount of text to a spreadsheet

    From your description, I think that your document might be better handled by Word with bookmarks, a well designed table of contents, or maybe even an index.
    Each scenario could be formatted as required without affecting other scenarios.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    05-30-2016
    Location
    North Carolina
    MS-Off Ver
    2013
    Posts
    6

    Re: adding a large, LARGE amount of text to a spreadsheet

    Thank you Richard and newdoverman. It is critical that the scenario show up on the excel sheet and is tied to a practice. The challenge is that there 97 codes and over 200 practices with individual scenarios (it is a tangled mess, that in true government fashion is all ad hoc). I will look at making some changes based on your suggestions and see if this helps. Thank you so much for your help. I know that Excel is not a word program, but in this case I am hoping to blend the two to reduce confusion. Thank you both again for your prompt help, I will try the suggestions out and see if they work. Thanks again.

    John

  5. #5
    Registered User
    Join Date
    05-30-2016
    Location
    North Carolina
    MS-Off Ver
    2013
    Posts
    6

    Re: adding a large, LARGE amount of text to a spreadsheet

    Richard, thank you so much. your suggestion has helped me create a usable and professional document. Thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 03-06-2014, 05:43 PM
  2. Replies: 6
    Last Post: 09-27-2012, 10:45 AM
  3. Help replacing large amount of text with another large amount of text??
    By floydrob in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2012, 05:01 AM
  4. [SOLVED] how do I import a large amount of text into one cell?
    By Avid Marine in forum Excel General
    Replies: 0
    Last Post: 01-02-2006, 03:55 AM
  5. [SOLVED] Display large amount of text in form
    By JG Scott in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2005, 12:45 PM
  6. How do I paste a large amount of text into a cell ?
    By Gal Mariansky in forum Excel General
    Replies: 1
    Last Post: 11-04-2005, 01:40 PM
  7. [SOLVED] Fit large amount of text in 1 cell
    By Carl W. in forum Excel General
    Replies: 5
    Last Post: 06-27-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1