1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Require to save separate file in fix path for each unique subtotalled instance via inputbox

Discussion in 'Ask an Excel Question' started by Chirag R Raval, Apr 21, 2017 at 6:28 AM.

  1. Chirag R Raval

    Chirag R Raval Member

    Dear All

    Sub:-Need to generate & save separate file for each unique subtotalled instance
    if put require instance in input box, (input box can take 1 or more then one instance )
    or it ask for save separate file for all unique instance in fixed path directory (Folder)

    I have a file

    subtotalled on first main criteria

    then also subtotalled another criteria for it main criteria (2 levelled subtotal-for each instance)

    I require separate file for each unique main first subtotalled instance
    with all data (with all 2nd level subtotal) preserved with all formatting & heading.

    purpose -Just extract & mail for that instance

    any one can help??
  2. SirJB7

    SirJB7 Excel R┼Źnin

    Hi, Chirag R Raval!
    Consider posting the sample file and write down the desired output.
  3. Chirag R Raval

    Chirag R Raval Member

    Dear Sir,
    Attached my sample file
    with requirement-

    (1) Input box for put Required Buyer No (May be 1 or more )
    in it Each Instance of Subtotalled Party
    generate as separate file & auto save on fixed path
    with all formatting, 2nd level subtotal & heading preserved.

    Purpose-Mail for that party

    Hope-your co-operation


    Attached Files:

Share This Page