+ Reply to Thread
Results 1 to 2 of 2

How to take a text only spread sheet, select specific info and print as a report

  1. #1
    Registered User
    Join Date
    08-21-2017
    Location
    Corby, England
    MS-Off Ver
    Excel 2016
    Posts
    2

    Red face How to take a text only spread sheet, select specific info and print as a report

    Hi,

    Imagine a big spread sheet holding lots of data regarding customers. Each row is a different company and each column holds specific information regarding that company. I need to select certain rows and then print the company information as a summarised report. The report should consist of a table with two columns, the first column will hold the company headline info so lets say columns a, b, c and K - the data can simply be shown as follows:

    (a) Company code: BBC002
    (b) Company name: the fake company
    (c) Company area code: GB
    (k) Company description: A fake company founded in 2017 as a way of explaining myself in an Excel forum.

    Then the second column for the fake company will hold more fields with more specific information as in column 1.

    As I don't even know what this function is called I am unable to search for it and follow a tutorial so even if you aren't sure how to achieve it but know what I need to research that would be of great help.

    Thanks

  2. #2
    Registered User
    Join Date
    08-21-2017
    Location
    Corby, England
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: How to take a text only spread sheet, select specific info and print as a report

    I notice lots of people reading my post but does nobody know what the function is called???

+ 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. [SOLVED] If any cell a sheet contains specific text then select column to last used row
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-12-2016, 06:52 AM
  2. [SOLVED] VBA: Select...Case to Print specific sheet only
    By hydz1213 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2013, 02:25 AM
  3. How to collect daily report from spread sheet and accumulate for monthly report
    By yshguru in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2013, 05:17 PM
  4. Generating New Spread Sheets with Info from the very last work sheet
    By jasw529 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-28-2013, 08:52 AM
  5. Taking info from 1 spread sheet to another
    By redhand in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-23-2008, 08:32 AM
  6. Pulling info from Goldmine into a spread sheet
    By ETI Systems in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-05-2006, 07:10 PM
  7. [SOLVED] How do you add an Excel spread sheet to a Microsoft Word report?
    By RaymondTBirmingham in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2005, 04:06 AM

Tags for this Thread

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