Results 1 to 15 of 15

Automatic Search/Copy/Paste Between Sheets, How?

Threaded View

Mogadeet Automatic Search/Copy/Paste... 03-13-2009, 12:06 PM
Leith Ross Re: Automatic... 03-13-2009, 12:44 PM
Mogadeet Re: Automatic... 03-13-2009, 01:19 PM
Leith Ross Re: Automatic... 03-13-2009, 01:46 PM
JBeaucaire Re: Automatic... 03-13-2009, 01:49 PM
Mogadeet Re: Automatic... 03-13-2009, 01:56 PM
Mogadeet Re: Automatic... 03-13-2009, 02:15 PM
Mogadeet Re: Automatic... 03-13-2009, 02:36 PM
Leith Ross Re: Automatic... 03-13-2009, 06:47 PM
Mogadeet Re: Automatic... 03-16-2009, 07:02 AM
Mogadeet Re: Automatic... 03-23-2009, 11:27 AM
siamadu Re: Automatic... 03-23-2009, 12:07 PM
Mogadeet Re: Automatic... 03-23-2009, 12:22 PM
Majharul Automatic Search/Copy/Paste... 06-16-2012, 04:12 AM
arlu1201 Re: Automatic... 06-16-2012, 06:51 AM
  1. #1
    Registered User
    Join Date
    03-13-2009
    Location
    Defiance, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    21

    Automatic Search/Copy/Paste Between Sheets, How?

    I would like Excel to do the following and have no idea how to write the instructions. The function is as follows:

    From a general information sheet (sheet #1), XCEL looks at a cell to determine if that cell holds "A" or "B" (will be a word, and choice will be previously fixed by a dropdown menu). It then looks at another cell in the same row to determine if it equals 0 or 1.
    If the cell holds A, and the other cell holds 0, XCEL copies the row from the general information sheet onto sheet #2 of the same workbook.
    If the cell holds B and the other cell holds 0, XCEL copies the row from the general information sheet onto sheet #3 of the same workbook.
    After XCEL has copied a row, it inputs a 1 in a final cell of that row so it will not copy that row again.
    On sheet #2 and sheet #3, XCEL begins (and copies to) the first open row in column A (by moving there after performing its last copy function or by checking column A until it finds a cell = 0), so that each new copy function begins in an open row.

    Is this even possible?

    If it is, how would I write it?

    Mogadeet
    Last edited by Mogadeet; 03-23-2009 at 11:26 AM.

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