Results 1 to 6 of 6

Output Table to Separate Workbooks

Threaded View

Pantoffels Output Table to Separate... 09-12-2013, 05:42 AM
Pantoffels Re: Output Table to Separate... 09-12-2013, 07:53 AM
HaHoBe Re: Output Table to Separate... 09-12-2013, 08:06 AM
Pantoffels Re: Output Table to Separate... 09-12-2013, 08:27 AM
Pantoffels Re: Output Table to Separate... 09-12-2013, 10:31 AM
HaHoBe Re: Output Table to Separate... 09-12-2013, 06:10 AM
  1. #1
    Registered User
    Join Date
    05-20-2013
    Location
    South Africa
    MS-Off Ver
    Office 2013
    Posts
    11

    Output Table to Separate Workbooks

    Hi,

    I'm looking for a macro that can do the following...

    I have a static excel header in rows 1 to 12.
    Data runs from A13 to O300
    Column headers run in Row 12.

    I would like to filter each unique value in Column C and save it to a separate Excel file labelled with the name in Column C.
    Also, keeping the header information intact for each outputted document.

    See an example attached.

    With thanks
    Attached Files Attached Files
    Last edited by Pantoffels; 09-12-2013 at 05:50 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help required for a tricky problem(s)
    By zybatu01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-03-2008, 12:19 PM
  2. Help with a Tricky Macro
    By bobgoblin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2007, 02:14 AM
  3. [SOLVED] tricky macro
    By cjupiter in forum Excel General
    Replies: 0
    Last Post: 02-09-2006, 09:40 AM
  4. Replies: 2
    Last Post: 09-14-2005, 08:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1