Excel sheets automation
$10-30 USD
Paguhet në dorëzim
I am searching for an Excel expert who possesses strong skills in Macro programming.
I have different excel files organized in different directories with the same data structure.
I need to create a main excel that contain all this data in only one sheet with an automation. (This process needs to be done every 15 days, so needs to be automated)
What we do now is to enter to each sheet and copy the data into a main excel and its a lot of manual work.
Some requeriments:
1) the row on each excel sheet needs to be added to the main file only when the column 2 ("Fecha de ingreso (dd/mm/aaaa)" is not empty, if not the row should be not consider.
2) There should not be empty rows in the "Main excel"
3) The titles should appear only once in the main excel, as the data structure is the same.
4) Column BN should be the "source excel name of the row"
5) Column BO should be the subdirectory name of the "source excel name of the row"
6) Column BP should be the previous subdirectory name of the "source excel name of the row"
For example the file is contained in: RM.2023->TilTil->Planilla_registro_SPLV_2023_AltosdelHuerto
RM.2023 name should be in column BP, TilTil name should be in column BO and Planilla_registro_SPLV_2023_AltosdelHuerto
The idea is to put all the data in only one excel sheet with the same data structure and keep the information of the files and subdirectories that this data was organized.
ID Projekti: #37679647
Rreth projektit
62 profesionistë freelancer dërguan një ofertë mesatare prej $25 për këtë punë
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Më shumë
"""""""""""""""""""""""""""""""""""ADVANCE EXCEL EXPERT/EXCEL SHEET AUTOMATION """""""""""""""""""""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and Më shumë
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply.
Hi, Sure..., You will get an Excel file with a Script/Macro to automate collecting data from several files from different locations into one sheet with all the processing conditions applied as required. "
Hello, My strong analytical skills and proficiency in using Excel and Google Sheets enable me to provide solutions for most problems, including VBA programming. If you choose to work with me, you can expect to recei Më shumë
As a highly experienced data professional with over 12+ years of working with major brands like IBM and Accenture, I understand the importance of efficiency and automation in tasks. I have extensive experience working Më shumë
Hi, I have fairly understood the requirement you have described have thought of a very good and user-friendly solution. Please feel free to message me any time to discuss my proposal further. I truly look forward to a Më shumë
"""""""""""""""""""""""""""TOP EXCEL VBA EXPERT"""""""""""""""""""""""""""" Greetings! I clearly understand what is required of the project. I am an EXCEL Advanced Level Expert. I have extensive experience in Excel, p Më shumë
Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of data Microsoft applications Development. I can write clean, Excel, Word, Access, Power Më shumë
Hi, I develop Excel macros (VBA scripts) that automate data processing, sending email, interacting with external sources. With my extensive experience in data management, I will ensure the successful completion of this Më shumë
Hi Good afternoon I would be a fabulous fit for this task. I read your details, and I'm ready to start now. I have expertise in Data Processing, Excel, Visual Basic, Software Architecture and Visual Basic for Apps I Më shumë
As a seasoned professional with 15 years of experience in the tech industry and a specialised focus on Excel VBA and macros, I am well-equipped to tackle your project with utmost precision. In the past, I have successf Më shumë
Hi there, I am expert in excel and provides you the best automation in excel. I provide efficient excel services and gives you the best quality work delivery in your budget. Thanks & Regards, Asad Ahmed
With the daunting task you've described of merging data from various Excel files into a single, well-structured workbook, my expertise in Excel automation and data processing makes me the ideal candidate for this proje Më shumë
Good Day, I hope this message finds you well. I am thrilled about the opportunity to collaborate with you on your data automation project. With a strong background in Finance and over 15 years of experience in educat Më shumë
As a passionate aficionado of everything data, I have spent the past decade honing my skills in Microsoft Excel, not to mention my expertise in Visual Basic which would be incredibly valuable for automating the task at Më shumë