+ Reply to Thread
Results 1 to 2 of 2

Need help with making a copy paste macro!

  1. #1
    Registered User
    Join Date
    05-11-2017
    Location
    Singapore
    MS-Off Ver
    MS Office for Mac and Windows
    Posts
    1

    Post Need help with making a copy paste macro!

    Hi friends,
    I am trying to clean up and data file and would like to automate the process to some extent to save on time. What I am looking to do in for excel to search any rows for all the data in columns C to J for values which are S(----), numbers in brackets. The numbers can be anywhere between 1 to 10 and the excel should ignore the number of digits inside the brackets. The trigger to find should be S(). I am also looking to search this even if its input as part of the same word/address. It should then cut and paste this data to column K. I have attached screenshot of the file for better understanding. Appreciate the help and guidance on this. Thanks!
    DataFile.png

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,307

    Re: Need help with making a copy paste macro!

    Hi JohnLeo12

    Welcome to the forum.
    Please attach a sample workbook with a before & after scenario making sure that your desired solution is shown - mock up the results manually if need be. This will make it easier for us to create the correct code.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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] Making Copy and Paste with .end offset more efficient
    By Ragnarok_421 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2014, 02:06 PM
  2. Need help making a macro that will find, copy, and paste a cell with a comma in it
    By EricC PhD in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-12-2012, 04:38 PM
  3. Help making a copy paste Macro for data from drop down list
    By sleep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2012, 05:21 AM
  4. [SOLVED] Need Help with making copy and paste code faster
    By Wes88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2012, 10:36 AM
  5. Running a macro and making it paste into the next blank cell.
    By connor8392 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-13-2010, 05:16 AM
  6. Running a macro and making it paste into the next blank cell.
    By CAMTHEMAN20 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-12-2010, 10:09 PM
  7. Making Copy and Paste Code more efficient
    By T De Villiers in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2006, 11:31 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