+ Reply to Thread
Results 1 to 3 of 3

To copy and paste as I want

  1. #1
    Registered User
    Join Date
    05-17-2019
    Location
    Lithuania
    MS-Off Ver
    2007
    Posts
    1

    To copy and paste as I want

    Hello everybody,

    First of all I am very happy that I found place like this forum. Thank you for all of your contribution.

    Long story short - I need to copy this kind of information multiple times (screenshot below):
    45ddf8a9466251a32f4aa3796a154c3a.png
    Information from screenshot is different but it has only options from 1 to 20. What I mean that it has 20 different texts which can be shown as possible.

    So, once i copy it to the excel it comes out like this (screenshot below):
    429c15e7decbcc4b569b50a918e03f8f.png

    And I need it to look like this (screenshot below):
    70a88ecaf947015ddba131e967f1a148.png

    I need that excel would recognize specific text, for example word strong has to be recognized as number 8. And most important once it is pasted into excel i need all the lines to go to the different columns. What i mean, that Inside shouting would go under IS column and the rating would appear under that specific column.

    Is it hard to make it work like this? I know that people once already made this thing but I have lost contact with these people.

    Even if nobody will help me - Thank you for your time reading. I hope everything will be good in your life.

  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: To copy and paste as I want

    Hi and welcome to the forum

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context. Pictures are rarely much use and no one wants to spend time creating a workbook you already have

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    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
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: To copy and paste as I want

    What has this to do with Word, which is the forum you've posted in?
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ 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: 01-01-2015, 06:26 AM
  2. How do I make the copy/paste of one column contingent on the copy/paste of another?
    By Kwasimitsu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2014, 01:51 PM
  3. [SOLVED] Copy Paste Loop ends before copy/paste is finished
    By brgr4u in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-08-2013, 04:01 PM
  4. Automate copy and paste and copy and paste back to excel
    By Bmw318be in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2013, 05:42 AM
  5. Replies: 1
    Last Post: 01-16-2013, 05:36 AM
  6. 2 Macro's: only vertical copy/paste action and copy-paste 14 columns to the right.
    By vdongen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2010, 10:34 AM
  7. Replies: 1
    Last Post: 01-04-2005, 06:06 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