+ Reply to Thread
Results 1 to 2 of 2

HELP - IF cell contains certain word then copy row and paste on to another sheet

  1. #1
    Registered User
    Join Date
    03-14-2016
    Location
    Melbourne
    MS-Off Ver
    2010
    Posts
    0

    HELP - IF cell contains certain word then copy row and paste on to another sheet

    Hi guys,

    I've looked at various forums but not quite working out for me. I'm new to VBA and looking to do the following:

    Within a sheet called JAN, go down column H and for every item which has a status of "Deferred", copy that row up to column E and paste on to a sheet called DEFERRED TASKS and paste into the first empty cell within column A after cell A5 (so see if A5 is empty, if so paste the row there, else if it contains data in A5 already, then see if A6 is empty and if so paste the row into there etc).

    I would like it so that when they press a Macro button within sheet DEFERRED TASKS, it will scan through sheet JAN down column H, and look for all the rows containing a status of "Deferred", and copying the row up to column E. So effectively when you come to this DEFERRED TASKS page, you should be able to click a button and see all the tasks which have been deferred for the month of January.

    Ideally, for each tab (JAN/FEB/MAR/APR) etc, I am going to repeat so that when you press this button, it'll scan through all of JAN data and look for deferred tasks and paste into the DEFERRED TASKS page, and then scan through all of FEB and continue the pasting. It will also be great to know where the data came from (i.e. if the line was copied and pasted from JAN data, have the column on the right say JAN so that we know originally the data came from the January tab.

    Example sheet attached.

    Any assistance would be highly appreciated!!!!!

    Thanks guys

    sK
    Attached Files Attached Files

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello scottkim87,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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 horizontal range and paste into other sheet if column contains word
    By mangesh.mehendale in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-20-2015, 03:43 AM
  2. [SOLVED] Macro to find specific word in cell and then copy and paste the adjacent cell upwards
    By raytej82 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2014, 05:33 PM
  3. Replies: 2
    Last Post: 04-29-2014, 10:06 AM
  4. [SOLVED] Copy row from one sheet and paste to another if a key word is found in 1 column of sheet 1
    By killdozer in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-17-2014, 02:27 PM
  5. Copy/Paste row to another sheet based on word in column
    By mulcahcf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2010, 12:55 PM
  6. Copy and Paste from Word to Excel Cell
    By Gos-C in forum Excel General
    Replies: 5
    Last Post: 11-04-2008, 03:07 PM
  7. [SOLVED] copy a list of items from word and paste in cell
    By Priscilla in forum Excel General
    Replies: 1
    Last Post: 11-11-2005, 02:51 PM

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