Posts by hkk

    Dear Friends,


    Can someone help me with below? How can I modify below code to consolidate 8 data files into 1 file using a similar setup as "SplitRpt" .
    Please help me in this context since I am incompetent in VBA programming. [Blocked Image: http://www.vbaexpress.com/forum/images/smilies/sad2.gif]

    **************************
    "SplitRpt" Sheet Content


    CUST SPLIT BY VALUE APPEND_FILENAME REMARK
    AVG PKG SC70 _SC70
    AVG PKG SOT _SOT


    Suggesting setup as below :
    Every cust has one folder each with its own data. Need to consolidate all 8 cust excel sheet into 1 sheet by maintaining the existing folders and data for each cust. Which means every cust folder will still have separate cust data but under each folder will also have an additional sheet of the consolidated version.How can I modify the above code to achieve this?


    CUST APPEND_FILENAME
    SGC _ST
    SGG _ST
    SGF _ST
    SGS _ST
    SGT _ST
    SGE _ST
    SGU _ST
    SGR _ST


    Thank you in advance.