+ Reply to Thread
Results 1 to 2 of 2

Create a report with data from cells, and standard text.

  1. #1
    Registered User
    Join Date
    05-27-2009
    Location
    Bucharest Romania
    MS-Off Ver
    Excel 2007
    Posts
    29

    Create a report with data from cells, and standard text.

    Hey,...

    Is there any way that i can create a report with data in the excel file:
    example
    "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sodales viverra venenatis. In rhoncus sollicitudin odio, quis scelerisque ipsum faucibus a. Vivamus placerat, risus quis porta scelerisque, lorem erat interdum justo, quis cursus risus velit et metus. Maecenas purusdata from sheet x, b5, hendrerit id consectetur quis, tempor a erat. Nullam tempus posuere metus, id volutpat orci semper ut. Vivamus quis risus vitae diam blandit vestibulum. Nam fermentum purus id nunc varius non porttitor nunc aliquet. Curabitur at nunc a leo condimentum venenatis ac in nunc. Aliquam erat volutpat. Aliquam eros est, porta in venenatis ac, molestie eu est. Sed faucibus tincidunt erat, vel lobortis nunc viverra eu. data from sheet y, d4 fermentum diam quis quam consectetur mollis. Nunc id consequat tellus. Donec ultrices vulputate tortor ut tincidunt. Mauris vitae data from a sheet, and a cellvel nunc feugiat hendrerit ut id lorem. Sed ullamcorper augue in lectus mattis a porttitor erat porta. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Maecenas molestie porta lorem, porttitor ornare augue consectetur in. "

    I hope you understand what i want...

    I want to make a standard price offer, but with linked with the cells in the worksheet

  2. #2
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: Create a report with data from cells, and standard text.

    You could use the concatenate function. For example:

    ="Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla sodales viverra venenatis. In rhoncus sollicitudin odio, quis scelerisque ipsum faucibus a. Vivamus placerat, risus quis porta scelerisque, lorem erat interdum justo, quis cursus risus velit et metus. Maecenas purus"& Sheetx!B5&", hendrerit id consectetur quis, tempor a erat. Nullam tempus posuere metus, id volutpat orci semper ut. Vivamus quis risus vitae diam blandit vestibulum. Nam fermentum purus id nunc varius non porttitor nunc aliquet. Curabitur at nunc a leo condimentum venenatis ac in nunc. Aliquam erat volutpat. Aliquam eros est, porta in venenatis ac, molestie eu est. Sed faucibus tincidunt erat, vel lobortis nunc viverra eu. "&SheetY!D4&" fermentum diam quis quam consectetur mollis. Nunc id consequat tellus. Donec ultrices vulputate tortor ut tincidunt. Mauris vitae"&SheetZ!A1&", and a cellvel nunc feugiat hendrerit ut id lorem. Sed ullamcorper augue in lectus mattis a porttitor erat porta. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Maecenas molestie porta lorem, porttitor ornare augue consectetur in. "

    ...should work?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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