+ Reply to Thread
Results 1 to 3 of 3

Copy rows from master sheet to other sheets if certain cell in column is blank

  1. #1
    Registered User
    Join Date
    07-28-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    4

    Copy rows from master sheet to other sheets if certain cell in column is blank

    Hi all

    I am very new to this forum so please forgive me if I have posted in the incorrect place.
    My knowledge of excel is limited so if anyone is able to help me out, I would appreciate it!

    I have a master worksheet. with "X" in certain columns. what I need now is for something automated...

    If there is not an "X" in column E ,I would the information in column B&C of that row to copy to another sheet(Cred app OS).

    And exactly the same for column F, G,and H to their own individual sheets.

    Hope it is clear!
    Attached Files Attached Files

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Copy rows from master sheet to other sheets if certain cell in column is blank

    When you say exactly the same for F,G,H does that mean you would want "B:C & F:H" moved or copied to the Cred app OS sheet?
    Not all forums are the same - seek and you shall find

  3. #3
    Registered User
    Join Date
    07-28-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Copy rows from master sheet to other sheets if certain cell in column is blank

    Sorry what I meant was that within column F(Debtors Master), all rows that do not contain an "X" the info from Column B&C is to be copies to the tab "Credit App OS".

    Then for Column G(Debtors Master) all rows that do not contain an "X" the info from Column B & C is to be copies to the tab "VAT Cert OS".

    Then for Column H(Debtors Master) all rows that do not contain an "X" the info from Column B & C is to be copies to the tab "Accs to close".

    Then if in Column E,F,G,H (Debtors Master) there are no "X"s in any of these columns, the information from that specific row is to be copied to the tab "No Apps Sent".

    I hope this is not a difficult request, however with excel im sure its possible, I just do not have the knowledge as yet.

    Also All this bearing in mind that on the Debtors Master tab the information will be changed regularly and inturn update the other tabs at the same time.

    THANKS

+ 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