Copy -2 leveled subtotaled data -whole 1 instance from that data to another file based on dialogbox input & can be multiple input

[chirag050675]

Dear Sir,

I have an excel file with subtotalled of on 2 level-- first Buyer No. wise & Then Month wise.
for each buyer no wise data need to generate new Excel file with all Subtotal Structure as it is (with Month wise)
for that buyer.

Buyer No column is first column (A).

its known that if you subtotal on some criteria there are just starting with that criteria heading & ending with words
" Criteria Total". the gape (Blank Cells) between start to end is depend on database.

need is if I put 1 , 2 or more buyer no in dialog box , generate separate files for each buyer no's
in fixed location with also 2nd level subtotal (Month wise) with all Structure of Subtotal & formatting preserved.

that's it

Hope you co-operation

Regards,

Chirag

 

[chirag050675]

Can anyone help??

 

[chirag050675]

 

[chirag050675]

Excel 2010ABCDEFGHIJKL1BUYPARTYSRDPBRANDBLNDMATU****QTYEXGRP211301 (START FROM HERE)A. I. & CO.4451SAPPHIRE3041005384-00081115.00551PWR311301A. I. & CO.4451SAPPHIRE3041005384-00091115.00551PWR411301A. I. & CO.4451SAPPHIRE3041005384-01131115.00551PWR51 Total345.00611301A. I. & CO.7642TOP LINE4040015237-00101115.00358PVF711301A. I. & CO.7642TOP LINE4040015237-00291115.00358PVF811301A. I. & CO.2792TESORO3298078800-02361115.00992PWP92 Total345.001011301A. I. & CO.3183PREMIUM TROUSERING3182110823-00031115.00948PWP1111301A. I. & CO.8053ENDURA4018111177-00011115.00335PVF1211301A. I. & CO.3543EXCELLENCE3428112547-00441115.00728PWR133 Total345.001411301A. I. & CO.3544EXCELLENCE3428112547-00471115.00728PWR1511301A. I. & CO.3544EXCELLENCE3428112547-00481115.00728PWR1611301A. I. & CO.3544EXCELLENCE3428112547-00911115.00728PWR174 Total345.001811301A. I. & CO.3545EXCELLENCE3428112547-01021115.00728PWR1911301A. I. & CO.3855S.FINE SAPPHIRE3427112840-00541115.00775PWR205 Total230.002111301 Total (TILL HERE)14210.002211302 (2ND FILE START
FROM HERE)RAYMOND EMPORIUM4451SAPPHIRE3041005384-000860112.00551PWR2311302RAYMOND EMPORIUM4451SAPPHIRE3041005384-000960112.00551PWR2411302RAYMOND EMPORIUM2371TECHNO STRETCH2377114995-000360112.00798PWP251 Total336.002611302RAYMOND EMPORIUM7342STERLING4056007138-00071115.00339PVF2711302RAYMOND EMPORIUM7342STERLING4056007138-00091115.00339PVF2811302RAYMOND EMPORIUM7342STERLING4056007138-00101115.00339PVF292 Total345.003011302RAYMOND EMPORIUM5903COOL EDGE9003010100-000660112.00522PVF3111302RAYMOND EMPORIUM5903COOL EDGE9003010100-005660112.00522PVF3211302RAYMOND EMPORIUM2793TESORO3298078800-000160112.00992PWP333 Total336.003411302RAYMOND EMPORIUM2794TESORO3298078800-014660112.00992PWP3511302RAYMOND EMPORIUM4894TRUE STAR3332109527-000860112.00489PWR364 Total224.003711302 Total  (TILL HERE)11141.00[CENTER][COLOR=#161120][B]TRS[/B][/COLOR][/CENTER]

Worksheet FormulasCellFormulaI5=SUBTOTAL(9,I2:I4)J5=SUBTOTAL(9,J2:J4)I9=SUBTOTAL(9,I6:I8)J9=SUBTOTAL(9,J6:J8)I13=SUBTOTAL(9,I10:I12)J13=SUBTOTAL(9,J10:J12)I17=SUBTOTAL(9,I14:I16)J17=SUBTOTAL(9,J14:J16)I20=SUBTOTAL(9,I18:I19)J20=SUBTOTAL(9,J18:J19)I21=SUBTOTAL(9,I2:I19)J21=SUBTOTAL(9,J2:J19)I25=SUBTOTAL(9,I22:I24)J25=SUBTOTAL(9,J22:J24)I29=SUBTOTAL(9,I26:I28)J29=SUBTOTAL(9,J26:J28)I33=SUBTOTAL(9,I30:I32)J33=SUBTOTAL(9,J30:J32)I36=SUBTOTAL(9,I34:I35)J36=SUBTOTAL(9,J34:J35)I37=SUBTOTAL(9,I22:I35)J37=SUBTOTAL(9,J22:J35)

 

[chirag050675]