+ Reply to Thread
Results 1 to 4 of 4

HELP - DEADLINE TO MEET - NEWBIE - FAIRLY EASY ONE (Auto Copy Data from Sheet to Sheet)

  1. 04-23-2013, 05:23 PM #1
    laforce
    laforce is offline
    Registered User
    Join Date
    04-18-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    MS 365 Subscription
    Posts
    20

    HELP - DEADLINE TO MEET - NEWBIE - FAIRLY EASY ONE (Auto Copy Data from Sheet to Sheet)

    Good afternoon EF Experts. I'm under a deadlilne to come up with a solution to move invididual rows in a MasterSheet to other Sheets based upon criteria in Column E.

    We have investors in Fund1, Fund2 & Fund3. We also have 8 investment states. Whenever Stage 5 (Suntrust) through Stage 8 (Certificate Issued) is reached would like the work book to automatically COPY that investor to the partcular fund they have invested into.

    I have attached a sheet and thank you in advance for taking the time to review this for me.

    Tristan C.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-23-2013, 05:37 PM #2
    Lemice
    Lemice is offline
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: HELP - DEADLINE TO MEET - NEWBIE - FAIRLY EASY ONE (Auto Copy Data from Sheet to Sheet

    Hello,

    Please see attached file. All you have to do is drag formula in each Fund worksheet down until you see "blank" (no other investor to get). Currently I only drag it to row 10, so maximum is 10 investors per Fund can be found that is in stage 5-8.
    Also, all formulas are Array formulas, so when you edit / try to enter it, hold Ctrl-Shift then hit Enter (If you see it's wrapped in { } like in the sample, you've done it right)
    Attached Files Attached Files
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem
    Reply With QuoteRegister To Reply
  3. 04-23-2013, 05:41 PM #3
    laforce
    laforce is offline
    Registered User
    Join Date
    04-18-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    MS 365 Subscription
    Posts
    20

    Re: HELP - DEADLINE TO MEET - NEWBIE - FAIRLY EASY ONE (Auto Copy Data from Sheet to Sheet

    Thank you for the quick response. I'll take a look at it. PM me if your're available for contract work. Thanks!!!
    Reply With QuoteRegister To Reply
  4. 04-23-2013, 06:49 PM #4
    aydeegee
    aydeegee is offline
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: HELP - DEADLINE TO MEET - NEWBIE - FAIRLY EASY ONE (Auto Copy Data from Sheet to Sheet

    I like the array formula that Lemice produced. I only saw it after I had written a macro, so I thought I'd post the macro anyway!

    Regards
    Alastair
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1