Results 1 to 7 of 7

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

Threaded View

  1. #1
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 11-05-2012, 09:28 AM
  2. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1