• 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

    Hui...

  • 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

Dear Sir,


Great.. working Fine...BUT...

(1) "Save To New File Button" Gone After it's work. But only can Retain after manually click on the ribbon's Filter Button on & off .


(2) if require manually fill the empty cells , (for require first to last without blank) on that point... this process become meaningless...

(3) please add little code for save each generated new files save on desktop (for sample-working code for saving ...so we can change path as we desire)

actually "Manually" portion degrade this whole concept...

Other wise ....Second option is


from simple database (without subtotalled l-database)


  1. Extract required buyer’s data in separate file..do 2 level subtotal in this extracted file ....do some formatting on having word “Total” .....& save on fixed path

  2. Do this for just another required buyer.

    Can it possible in your this code?
Regards,

Chirag Raval
 
Dear Sir,


One humble request...


Mr. SirJB7's Code work perfect..& also it .loyal for which this thread generated ...& also we can respect for their valuable work...if you can just integrate your code in it for advance filter option of desired buyers

that can fulfil this thread's requirement.. & if worked ..its respectfully complete & gratefully complete ..LIKE “Good Smell in gold”


but if there are not found any solution ..then we have 2 options


  1. Manually enter buyer no on blank cell option can be handle by some coding

  2. Separate first buyer data from row data & subtotalled & save

hope your Co-Operation understand


regards,

Chirag Raval
 
Dear Sir,

from 2 level subtotalled data ...
For Only Filtered Set....
Each Unique Set...
Generate Separate file
Mr. SirJB7's Code work perfect working..
But its Generate Separate files for All Buyers...

Separate file required only for required buyers..

I am reattached same file with working code..for your reference..

Can It Be possible? through "Collection" Technique?

Regards,
Chirag
 

Attachments

  • EXTRACT UNIQUE INSTANCE OF SUBTOTAL (2).xlsm
    25.8 KB · Views: 1
Back
Top