+ Reply to Thread
Results 1 to 3 of 3

string and int selecting and printing

  1. #1
    Registered User
    Join Date
    11-20-2014
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    11

    Lightbulb string and int selecting and printing

    I have a table that returns a numerical value at the bottom only if all the requirements are met. If they are not it simply replies with 'FALSE' is there any way I can take this information and then on another page make it only print the numerical value. However, depending on what people input into the form it will change which column will have a numerical value. So it will need to read the 6 values decide which is a numerical value and then print it.

    I also have conditional formatting on the cells so only the cell with a numerical value is coloured in yellow and the rest are red. Is there also any way of the computer reading these colours?

    Thanks for your help,

    Thomas

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,067

    Re: string and int selecting and printing

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh

  3. #3
    Registered User
    Join Date
    11-20-2014
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    11

    Re: string and int selecting and printing

    Example.xlsx

    Here attached is an example of a simple version of what I need to do. I need the number to be printed at the end of each line. However, in real life they will change in the form so needs to work for each line with the same formula

    Thanks for the help

+ 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. Printing/Selecting Multiple Print Ranges
    By klucas31 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2014, 04:50 PM
  2. Selecting all Chart-type Worksheets for Printing to PDF
    By JonMulder in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2013, 01:59 PM
  3. [SOLVED] Selecting filtered cells for printing macro
    By MacGyver7640 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2012, 03:38 PM
  4. Selecting Certain Color Tabs and Printing as One Print Job
    By mgaworecki in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-04-2010, 03:33 PM
  5. selecting charts for printing
    By Tim in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2005, 11:05 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