Results 1 to 8 of 8

Macro to copy row title to a different sheet based on multiple column criteria

Threaded View

  1. #1
    Registered User
    Join Date
    12-05-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    6

    Macro to copy row title to a different sheet based on multiple column criteria

    Hi,

    I am having trouble figuring out the correct code that will copy the Row title on Sheet 1 to Sheet 2 based on criteria in columns E & F on Sheet one.

    The Criteria required needed to return the building name is no activity in 2014, column E, and activity in 2015 ,column F, any activity is acceptable both positive and negative. If the criteria is met I am trying to copy the building name to sheet two, if the criteria is not met then move on to the next row.

    I have attached an example spreadsheet. Also, if there are formulas that would work better I am not opposed to using them.

    Thanks in advance for the help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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