Results 1 to 6 of 6

macro to loop through data sheet , fetch 8 rows at a time and put in new sheet

Threaded View

  1. 09-02-2015, 09:21 PM #1
    nyree
    nyree is offline
    Registered User
    Join Date
    02-21-2013
    Location
    France
    MS-Off Ver
    Excel 2010
    Posts
    8

    macro to loop through data sheet , fetch 8 rows at a time and put in new sheet

    Hello
    I've searched the forums and I can't find exactly what I need.

    I would like to know how to create new sheets based on a summary sheet.
    Copy students names: from columns A and B in data sheet to columns A and B in destination sheet1

    Copy teacher's name: from column F in data sheet to cell B3 in destination sheet

    Fetch 8 rows (rows 2 - 9) then create new sheet and repeat for rows 10-17

    Any help would be greatly appreciated!
    Thanks
    Nyree
    Attached Files Attached Files
    Last edited by nyree; 09-02-2015 at 09:24 PM.
    Reply With QuoteRegister To Reply
« 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. Macro to select sheet and copy data from one sheet to another on new line every time
    By goatie43 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2015, 07:26 AM
  2. Need a macro to fetch data from different sheets and club into one sheet.
    By sam190 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2013, 03:27 AM
  3. fetch using rows and column values to the varable in other sheet
    By sulohith in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2013, 09:37 AM
  4. Macro to loop through and fetch data from multiple websites
    By wishkey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2013, 05:37 AM
  5. [SOLVED] How to fetch data from one sheet in excel and insert into another sheet using VB
    By gokul1242 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2012, 11:38 AM
  6. Need help to loop macro to import 100k rows per sheet until end.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2012, 02:07 AM
  7. Need help to loop macro to import 100k rows per sheet until end.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2012, 12:12 AM

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