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

Concluído Postado 1 ano atrás Pago na entrega
Concluído Pago na entrega

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 Visual Basic Processamento de dados Excel VBA

ID do Projeto: #35392492

Sobre o projeto

6 propostas Projeto remoto Ativo em 1 ano atrás

Concedido a:

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 Mais

$30 AUD em 1 dia
(149 Comentários)
6.6

6 freelancers estão ofertando em média $32 nesse trabalho

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 Mais

$30 AUD em 1 dia
(746 Comentários)
7.5
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 Mais

$39 AUD em 1 dia
(190 Comentários)
6.1
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 Mais

$50 AUD em 1 dia
(114 Comentários)
5.7
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 Mais

$20 AUD in 7 dias
(3 Comentários)
5.5
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 Mais

$20 AUD em 1 dia
(3 Comentários)
2.9