+ Reply to Thread
Results 1 to 2 of 2

Loop through rows, insert sheet for each and copy header with row to new sheet

  1. #1
    Registered User
    Join Date
    11-25-2014
    Location
    Lincoln, UK
    MS-Off Ver
    2010
    Posts
    19

    Question Loop through rows, insert sheet for each and copy header with row to new sheet

    Hi all,

    I have a bit of a project I have been tasked with as I am the only one with the vba experience needed. I have been able to play with various areas of what I need up to now but am stuck with this part of the task.

    I have a set of data that shows results for a list of individuals. We want to extract the data for each individual and forward to them. When it comes to it, I can sort the 'sending to them' part as have done that previously. My issue is pulling the individuals data from the main sheet and pasting into individual sheets. I so far have the following which correctly creates and names a sheet per row:

    Please Login or Register  to view this content.
    Is anyone able to help with getting the head and relevant row copied across to the new relevant sheet?

    My eventual requirement is to take the fields and populate a pre-set template!

    many thanks

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Loop through rows, insert sheet for each and copy header with row to new sheet

    Perhaps.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA codes to insert the rows and copy the first entire row text and insert sheet
    By PRADEEPB270 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2013, 05:05 AM
  2. Within a loop, need to copy all rows from one sheet to another upon matching criteria
    By ripvanbrown in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2012, 03:52 PM
  3. loop that copy rows to new sheet
    By ALLEYCAT38 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-27-2012, 01:47 AM
  4. Search header row for common text in cells and copy below rows to new sheet
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-19-2011, 02:23 PM
  5. Loop to copy rows to another sheet if value not contained in both
    By hotrod6657 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2011, 08:21 AM
  6. Loop/copy rows variable times to new sheet
    By ianmaggy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2009, 07:18 AM
  7. [SOLVED] Loop/copy rows variable times to new sheet
    By Patti in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-01-2005, 05:05 AM
  8. loop to copy selected rows to a new sheet
    By katey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2005, 10:01 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