+ Reply to Thread
Results 1 to 2 of 2

When cell in column contains value, then copy cell on right and paste in another column

  1. #1
    Registered User
    Join Date
    08-11-2021
    Location
    Bristol
    MS-Off Ver
    2019
    Posts
    2

    Question When cell in column contains value, then copy cell on right and paste in another column

    Hi there, I'm having trouble figuring this one out, I'd like to include this code in a macro that sorts some information out for me, but for the life of me can't find a code that will just select a column on the left/right without putting the exact cell name, which is not what I want.

    Here's basically what I'm trying to do:

    If Cell range KO contains the word "How" then copy cell to the right (KP) and paste to column KQ in the same row.
    The excel sheet I will have will have hundreds of varying text, so it needs to just select the column on the right and then paste the text to the next cell on the right, I can't code it to know the cell it will go into which is where I'm lost.

    I've added a photo to make this more clear, as I'm not sure if I've explained this very well, most appreciated in advance anyone that can help me out!

    exceleeeeeeeeeee.PNG

    excel2.PNG
    Last edited by RoseMurphy; 08-11-2021 at 07:34 AM.

  2. #2
    Registered User
    Join Date
    08-11-2021
    Location
    Bristol
    MS-Off Ver
    2019
    Posts
    2

    Re: When cell in column contains value, then copy cell on right and paste in another colum

    Thank you for any help with this
    Last edited by RoseMurphy; 08-11-2021 at 07:35 AM. Reason: I found out how to edit the original image but can't figure out how to delete my comment

+ 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] copy the word within the cell of a column and paste in other cell of column
    By anuwers in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-12-2020, 06:19 PM
  2. copy Formula & paste in same column next cell when previous column is not blank
    By sanjuss2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-03-2020, 01:59 AM
  3. [SOLVED] Copy Cell From One Cell and Paste to next blank cell, Loop until last row/column
    By Beginner Level in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2020, 02:38 AM
  4. [SOLVED] VB Code to copy paste data from column to another column based on content of cell
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2019, 08:50 PM
  5. If column B cell is a certain value then copy and paste the value to column A
    By Snaybot in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2015, 08:23 PM
  6. Copy data and paste to another column incrementing that column to next empty cell
    By edens2021 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2015, 11:43 AM
  7. [SOLVED] Copy and Paste a specific Column to a Column that's heading matches a particular cell
    By Rexmond in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2012, 12:29 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