+ Reply to Thread
Results 1 to 8 of 8

Copy rows to a given sheet based on several criteria

  1. #1
    Registered User
    Join Date
    01-02-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    2

    Copy rows to a given sheet based on several criteria

    (posted as well here and here)

    I've been looking for a solution for this, but couldn't find the right one (or ones to combine).

    I have a sheet containing information.

    Criteria 1. Column D contains a date of service. As soon as a date is entered in this column, it means the service has taken place and the row can be copied to the given servicesheet (see criteria 2).

    Criteria 2. Column A contains a servicename, corresponding the sheet where the entire row has to be copied to. This column will basically be blank, and has to be chosen by the user by drop down menu. If a date is entered, and no servicename is given, an error should occur (if possible the error should occur after finishing the correct input).

    3. Both columns (A and D) can contain blanks. To define to last row (if needed) column H can be mentioned (every used row will contain a value).

    4. There are 20 (or so) different services, and 20 different sheets for these. For non existing services (sheets) an error should occur.

    Summarized: If a date and service is entered, the row has to be copied (and deleted from origin) to the sheet mentioned in column A, to the first blank row of that sheet.

    Thanks in advance!
    Last edited by bfora; 01-02-2013 at 09:52 AM.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: Copy rows to a given sheet based on several criteria

    Hello bfora,

    Welcome to the Forum.

    Please upload a sample WorkBook showing us what you have, and on another Sheet, how you would like the outcome to be.

    You have a number of brilliant Forum Members on your doorstep, so to speak, who would be most willing to assist you.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Copy rows to a given sheet based on several criteria

    welcome to the forum :-)

    however, I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: Copy rows to a given sheet based on several criteria

    @ JosephP,

    Good catch but,

    I insist on my money back! LOL

    Unless you indicate where else this Thread was Cross Posted.

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Copy rows to a given sheet based on several criteria

    no need-op has now done that as requested (though I recommend he or she does it in the other forums too!)

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: Copy rows to a given sheet based on several criteria

    @ JosephP,

    Tank you "JP"

  7. #7
    Registered User
    Join Date
    10-20-2010
    Location
    NL
    MS-Off Ver
    Excel 2003/2007
    Posts
    2

    Re: Copy rows to a given sheet based on several criteria

    Quote Originally Posted by Winon View Post
    @ JosephP,

    Tank you "JP"
    answered on http://www.mrexcel.com/forum/excel-q...ml#post3353923

  8. #8
    Registered User
    Join Date
    01-02-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Copy rows to a given sheet based on several criteria

    Thanks for advice and patience with newbies like me

    [...]

    EDIT: Problem is solved with this solution!
    Last edited by bfora; 01-02-2013 at 12:26 PM.

+ 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