Macro to to separate data from one excel file in multiple files in bulk

完了済み 投稿 １年前 着払い

$10-30 AUD

着払い

完了済み 着払い

I have a process which is very volume intensive, however the system uploading the data is only able to extract and upload one row (a days) worth of data per an excel file. Given the large volume of data which needs to be uploaded, I am wondering if there is a way I can split information from one excel into multiple files. The goal is aiming to avoid manually copying and pasting rows of data, then saving as a separate file.

For the required information I have an excel file which contains all of the data which I need to separate into multiple excel files. The files I need to generate as an output require a specific naming convention. All the data is in the same format. For example if I have fund name "Fund 1", then the date is 1/11/2022. I need to save the file name as "[login to view URL]".

Sample of the data, output file required and construction of the naming convention is attached.

エクセル ビジュアルベーシック 情報処理 Excel VBA

プロジェクトID: #35392492

プロジェクトについて

6個の提案 リモートプロジェクト アクティブ １年前

お金を稼ぎたいと思っていますか？

Freelancerで入札する利点

予算と期限を設定してください
仕事の報酬を受け取りましょう
提案のアウトラインを作成してください
登録して仕事に入札するのは無料です

アワード：

ineedWorkJobのプロフィール写真
ineedWorkJob

Hi Cal, I have read your project details and i will develop a macro/script that will split out your excel file into multiple files. I am open for discussion over chat/call. Sir, I can deliver this project soon もっと

$30 AUD 1日以内
(149レビュー)
6.6

6人のフリーランサーが、平均$32 で、この仕事に入札しています。

MimiFLのプロフィール写真
MimiFL

Hi, this is actually very common request, i went through the attached file (all 3 sheets) and i believe i can help you. I also have few simple follow up questions. If you are interested, feel free to message me and i w もっと

$30 AUD 1日以内
(746件のレビュー)
7.5
PERPETUAL0のプロフィール写真
PERPETUAL0

Hello there Iam excel EXPERT level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need t もっと

$39 AUD 1日以内
(190件のレビュー)
6.1
ha4401310のプロフィール写真
ha4401310

I AM AVAILABLE RIGHT NOW ------------------------------------------------ Greetings! ----------------- I’m very much interested to your requirements and Job openings. I am a Professional in VBA Macro Excel with more ye もっと

$50 AUD 1日以内
(114件のレビュー)
5.7
fanninson45のプロフィール写真
fanninson45

I can this Excel VBA Macro in no time. Getting this project started is a message away. SIMILAR PROJECTS I COMPLETED • https://www.freelancer.com/projects/microsoft-access/Microsoft-Access-VBA-Application/ • https://ww もっと

$20 AUD 7日以内
(3件のレビュー)
5.5
gm341473のプロフィール写真
gm341473

Dear sir, I have gone your project, and it matches my expertise.I'm confident of performing your project work. I have 6+ years of experience in Python, Bot Making, Software architecture. I can do your project accuratel もっと

$20 AUD 1日以内
(3件のレビュー)
2.9
このようなプロジェクトを投稿する