+ Reply to Thread
Results 1 to 1 of 1

macro to copy row to another sheet if row contains a certain word

  1. #1
    Registered User
    Join Date
    05-26-2011
    Location
    Bremen, Germany
    MS-Off Ver
    Excel 2010
    Posts
    1

    macro to copy row to another sheet if row contains a certain word

    I'll try to be as descriptive as possible.

    Current Status:
    I have an excel file with two sheets: Cost Breakdown and Noise Reduction (Fassade).

    The rows in the Cost Breakdown sheet which contain the word Noise in the column Ort need to be copied to the sheet Noise Reduction (Fassade).
    The whole sheet Cost Breakdown needs to be scanned and the rows which contain the word Noise copied and pasted into the sheet Noise Reduction (Fassade).
    If a value is changed in the a row containing the word Noise in the Cost Breakdown sheet, and this row already was copied to the sheet Noise Reduction (Fassade), this value has to be updated on the sheet Noise Reduction (Fassade) as well.
    If a new row containing the word Noise in the Ort column in the Cost Breakdown sheet is added, this row has to automatically appear also in the sheet Noise Reduction (Fassade).

    Attached I am putting an example of a workbook and how the desired output should look.
    Thank you very much.
    Attached Files Attached Files
    Last edited by avalcov; 05-26-2011 at 09:24 AM.

+ Reply to Thread

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