+ Reply to Thread
Results 1 to 5 of 5

How to "Copy Values" or have cell display text?

  1. #1
    Registered User
    Join Date
    10-07-2012
    Location
    here
    MS-Off Ver
    Excel 2003
    Posts
    5

    How to "Copy Values" or have cell display text?

    I am trying to create a description generator to standardize the way we name screws. I would like any user to be able to simply copy cell 'B6' and paste it into another program. Is there a way to do that besides copy B6, "paste value" in another cell, then copy/paste into another program?

    DESCRIPTION GENERATOR.xlsx
    DESCRIPTION GENERATOR.PNG

  2. #2
    Forum Moderator - RIP 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
    29,464

    Re: How to "Copy Values" or have cell display text?

    Don't you already have that in A7?

    Otherwise please explain step by step what you want to do and what the end result is and where.
    Richard Buttrey

    RIP - d. 06/10/2022

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

  3. #3
    Registered User
    Join Date
    10-07-2012
    Location
    here
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: How to "Copy Values" or have cell display text?

    Sorry Cell A7 is populates the choices of dropdown boxes into a "phrase". See picture. I just hid that row so no one would screw it up.

    Here is the goal: I want the user to use the drop down boxes to choose what screw they want. The format is automatically generated in cell B6. Then, I want a simple way for the user to be able to copy that exact name into another program to be pasted.

    DESCRIPTION GENERATOR 2.PNG
    Last edited by ckowalc; 01-12-2015 at 05:44 PM.

  4. #4
    Registered User
    Join Date
    10-07-2012
    Location
    here
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: How to "Copy Values" or have cell display text?

    Anyone have a method of doing this?

  5. #5
    Registered User
    Join Date
    10-07-2012
    Location
    here
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: How to "Copy Values" or have cell display text?

    Hmm so no one knows....

+ 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: 4
    Last Post: 02-20-2014, 02:24 PM
  2. Replies: 0
    Last Post: 11-22-2013, 01:36 PM
  3. [SOLVED] Formula needed to display "Pass" or "Fail" if a column contains any values other than "yes
    By andreindy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2013, 05:49 PM
  4. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM
  5. Replies: 1
    Last Post: 09-15-2010, 01:55 AM

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