+ Reply to Thread
Results 1 to 4 of 4

Transferring information from one sheet to another when a task is completed.

Hybrid View

  1. #1
    Registered User
    Join Date
    11-10-2011
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2003
    Posts
    2

    Transferring information from one sheet to another when a task is completed.

    Hello, I'm currently working on how to transfer my completed tasks at work to a separate page. I'm very lost! Please help!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,910

    Re: Transferring information from one sheet to another when a task is completed.

    Welcome to the Forum!

    I know you are in a desperate and distressed state but you have given no information about what you need to do or what your file looks like.

    Can you attach your file, describe what indicates that a task is completed, and explain how you want it to look on the other sheet?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-10-2011
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Transferring information from one sheet to another when a task is completed.

    I have included a simplified sample attachment. Basically what I want to figure out how to do is have the paid items (marked with an X) automatically transfer to a second spreadsheet so I can keep all non-paid items on the first sheet and paid items on the second sheet. Does this make any sense? Or is it possible to do? Thank you soooo much for your help!
    Attached Files Attached Files

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,910

    Re: Transferring information from one sheet to another when a task is completed.

    This can be done only with a macro. Attached is a solution.

    If you type any character under PAID, the row will be moved to Sheet2.
    Attached Files Attached Files

+ 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