Results 1 to 6 of 6

Please help transfer of data based on value of a Column

Threaded View

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    3

    Please help transfer of data based on value of a Column

    Hi,

    The workbook attached is something that I have been working on for a few weeks now and just don't have the knowledge to finish it off, What I am trying to do is to, base on the name in column "I" create a sheet with that name (if there is not already one) and place the information on that row from column "a" to column "m" on that sheet on the next avaible line on that sheet. So taking the first row as example: Column "I" has the name Rob Henry in it, therefore I need the code to create the new sheet with the column headings on it and then transfer line 3 columns "a-m" on the a sheet called Rob Henry.

    Please I have tried looking through a look of different forums and really can't make heads or tails of how to change some of the codes that are doing what I need to suit my needs, I thank anyone that can give me a hand sorting this problme out.
    Attached Files Attached Files

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: 12-17-2013, 09:59 AM
  2. Replies: 3
    Last Post: 12-12-2013, 04:00 PM
  3. Replies: 1
    Last Post: 05-04-2013, 06:42 PM
  4. Replies: 10
    Last Post: 12-25-2009, 08:10 AM
  5. Trying to Transfer Row(s) between worksheets based on Criteria in 1 Column
    By hockeyman in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-22-2008, 02:05 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