+ Reply to Thread
Results 1 to 7 of 7

To copy rows from one sheet to other sheets based on the first part of the named cell

  1. 09-25-2014, 01:01 PM #1
    JamesJohnson31
    JamesJohnson31 is offline
    Registered User
    Join Date
    09-25-2014
    Location
    U.S.A
    MS-Off Ver
    2010
    Posts
    20

    Cool To copy rows from one sheet to other sheets based on the first part of the named cell

    Hey all. First day and hope to advance in Excel VB script writing and macros but I have a delema (spread sheet attached). The spread sheet has 4 tabs. The master tab recieves a large bulk of information and I am hoping to copy the rows relevent to the other three tabs to thier sheet. It would be based on the partial names of the items in cell A1. An example would be copy all cells in A1 that start with the name "MED" and past them into the sheet named MED.

    The second issue I have is that column C is cluttered with data and I hope to one day extract the small information from that cell and delete the other clutter. It would be the user names that are in parenthesis that begin after the words "#6#TaskOwnerID IN". Crazy, I know

    Eventually I will need to have the two issues come together on their prespective Med, Neuro, and Peds tab. Any help out there would be greatly appreciated. Thank you.
    Attached Files Attached Files
    Last edited by JamesJohnson31; 09-25-2014 at 01:06 PM.
    Reply With QuoteRegister To Reply
  2. 09-25-2014, 02:52 PM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: To copy rows from one sheet to other sheets based on the first part of the named cell

    This may help with the first part.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 09-25-2014, 04:58 PM #3
    JamesJohnson31
    JamesJohnson31 is offline
    Registered User
    Join Date
    09-25-2014
    Location
    U.S.A
    MS-Off Ver
    2010
    Posts
    20

    Re: To copy rows from one sheet to other sheets based on the first part of the named cell

    Great! Thank you sir. I will work on it and try to make it work. Thanks again.
    Reply With QuoteRegister To Reply
  4. 09-26-2014, 06:10 AM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: To copy rows from one sheet to other sheets based on the first part of the named cell

    You're welcome. Glad to help out.
    Reply With QuoteRegister To Reply
  5. 09-26-2014, 10:22 AM #5
    JamesJohnson31
    JamesJohnson31 is offline
    Registered User
    Join Date
    09-25-2014
    Location
    U.S.A
    MS-Off Ver
    2010
    Posts
    20

    Re: To copy rows from one sheet to other sheets based on the first part of the named cell

    Good day Mr. Davis. With only a tweek or two, the code help was spot on and scalable so it helped out a lot. I'm still working on the column C issue and expiermenting with filters that will leave behind the unwanted clutter but no success yet. Thanks again.
    Reply With QuoteRegister To Reply
  6. 09-26-2014, 11:36 AM #6
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: To copy rows from one sheet to other sheets based on the first part of the named cell

    With the Column C issue maybe you could play around with the Left( function. If you to maintain so many characters of each cell. I don't know what to recommend.
    Reply With QuoteRegister To Reply
  7. 09-30-2014, 12:38 AM #7
    JamesJohnson31
    JamesJohnson31 is offline
    Registered User
    Join Date
    09-25-2014
    Location
    U.S.A
    MS-Off Ver
    2010
    Posts
    20

    Re: To copy rows from one sheet to other sheets based on the first part of the named cell

    Thank you all the same sir. I will keep plugging away. Your help has been most helpful and I am truly grateful.
    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)

Similar Threads

  1. Code to Create New Sheets Based on Cell Value, and Copy All matching Rows to New Sheet
    By CGL1235 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2012, 09:28 AM
  2. Excel 2007 : Copy rows from one sheet to different sheets based on cell value
    By Ireland316 in forum Excel General
    Replies: 2
    Last Post: 07-13-2012, 08:12 PM
  3. Copy rows from one sheet to different sheets based on cell value
    By Ireland316 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 04-26-2012, 06:17 AM
  4. Copy rows from work sheets to combine to one work sheet based on cell value
    By joemcmillen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2008, 05:04 PM
  5. Finding a named range based on cell value and copy/paste to same sheet?
    By Simon Lloyd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2006, 06:25 PM

Tags for this Thread

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