Results 1 to 6 of 6

VBA that will copy a given range of data with headers & save into new different workbooks

Threaded View

  1. #1
    Registered User
    Join Date
    05-20-2012
    Location
    Taiwan
    MS-Off Ver
    Office 365
    Posts
    47

    VBA that will copy a given range of data with headers & save into new different workbooks

    Hi

    I am having difficulties. All help will be greatly appreciated.

    I need a VBA to copy the header and only 5 rows (could be more than 10 columns) and saved into a different workbook with the name of the original file ending with an underscore and sequence number.

    Please refer to the attached file Test.xlsx (spreadsheet: Original Data) that has a header with 14 rows of data.

    Then the result VBA for this attached file would be;

    1) It would create 3 differnet workbooks
    2) Each workbook will have the header
    3) Each workbook will have 5 rows of the data (and the last workbook will have only 4 because the total number is only 14 rows).
    4) The name of each workbook would be Test_1.xlsx, Test_2.xlsx and Test_3.xlsx because there are 3 workbooks created.

    Thank you very much!
    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: 09-18-2014, 05:42 AM
  2. [SOLVED] How to Copy a filter data with headers, excluding the headers?
    By Elomaldo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-16-2014, 03:35 PM
  3. Need to Copy range of data from Multiple Workbooks to Single Worksheet
    By nuver101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2013, 12:58 PM
  4. Macro to open workbooks, process data, save copy as a csv
    By jdgwebdev in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-13-2013, 01:09 PM
  5. Creating a loop that will sort, copy, paste and save data into seperate workbooks
    By EggHead in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2009, 03:17 PM
  6. [SOLVED] How do I copy headers/footers to multiple different workbooks?
    By mjzvbms in forum Excel General
    Replies: 0
    Last Post: 08-16-2006, 11:15 AM
  7. [SOLVED] Copy same range of data from all workbooks and paste into consolid
    By JEFF in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-18-2005, 04:06 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