I usually process thousands even millions rows data in one excel file.
However, sometimes I will need to process the data separately, which i need a Macro to:
- separate/split hundred thousand even a million rows of data into multiple spreadsheets (e.g. 5000 rows data per each spreadsheet) &
- keeping the first row (header) in each files &
- automatically save as multiple excel files in csv format
7 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hello Sir, IN my team i have 8 yr+ Experience Excel, VBA, Micro Developer. he can develop a Micro for your task. i want your requirement in details. For more discussion feel free to chat .
Hello I am a senior developer so i can do it very easily if you want. Contact me right now i am ready to start this project for you. Low cost and high quality result reply to discuss more about this project
Hi, I am pleasure to edit excel document with sheet function and VBA. And I've made the VB program for simple task. Your require stimulates me. I think we can chat for detail.