Dear All
There is two wbk in attachments!
I required to export the wbk from wbk named sample and other is exported wbk!
There is 4 columns data in sample file.
Column A is data numbers, Column B id iD, column C is count of each wbk and column D id info!
Wbk will be exported based the count of column C, means first wbk will export 500 data, 2nd with 2500, 3rd with 100 and 4th with 150 and soo on (if more exist in said columns!) Total 4 wbk will be exported!
Removed all dashes, spaces leading trailing and wbk name will be =+B2&"-"&C2 and will save where the actual wbk exist!
All wbk will be exported with leading 0 to new wbk!
I made sample for only frist 500 data numbers! wbk will be exported in .CSV format!
thx
Bookmarks