+ Reply to Thread
Results 1 to 3 of 3

add header to each output.

  1. 02-11-2020, 08:42 PM #1
    troy79
    troy79 is offline
    Registered User
    Join Date
    12-26-2019
    Location
    australia
    MS-Off Ver
    2016
    Posts
    5

    add header to each output.

    Hi
    I am came across this script a couple of years ago.

    it splits my excel files into smaller chunks but it drops the header, how do I modify it so it retains the header on each new file?

    Thanks

    Please Login or Register  to view this content.
    Last edited by jeffreybrown; 02-11-2020 at 08:46 PM. Reason: Please use code tags!
    Reply With QuoteRegister To Reply
  2. 02-11-2020, 08:59 PM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: add header to each output. 

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
  3. 02-11-2020, 09:04 PM #3
    troy79
    troy79 is offline
    Registered User
    Join Date
    12-26-2019
    Location
    australia
    MS-Off Ver
    2016
    Posts
    5

    Re: add header to each output.

    Thank you
    Last edited by jeffreybrown; 02-11-2020 at 09:22 PM. Reason: Please try to avoid using full quotes!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Get values from input table to add data in output table depending on header
    By SBBmaster09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2016, 03:25 AM
  2. Compare values and output cell titles, able to output multiple results
    By TMG2016 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-07-2016, 11:42 AM
  3. [SOLVED] Cell reference, output dates to numeric. Should output as text
    By lifeseeker1019 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-02-2015, 05:51 PM
  4. Need the Maximum Output as Header
    By sriku in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-09-2014, 01:52 PM
  5. Find value in column with header and output variable in same row, different column
    By ggibs7 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-01-2013, 06:25 AM
  6. [SOLVED] Copy a specific column data of filtered output without header
    By uvaidya in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-05-2012, 09:21 AM
  7. Header Name output
    By meetmhatre in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2012, 06:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1