Automate data flow over several shared Spreadsheets - 28/04/2018 09:25 EDT

Previously worked on this type of projects. Not typing a lot as not sure if this is a true project.

Hy friends join Relevant Skills and Experience My project is very important ok

I will try myself to satisfy you completely

Hello. I know I am perfect for your jobs because I am very good at this. I already have experience as a call center operator for credit recovery, back office, administrative and front office/reception, institution for the protection of the pensioner, photocopier (ASL), after graduation I attended a course to deepen computer skills and as a native Roumanian speaker I also speak fluent Italian and English.I think I am a sociable person, dynamic, willing to learn, precise, reliable and particularly interested in the professional profile you requested. I'm available immediately

My day to day job involves data analysis and monitoring of performance, hence we need to make everything automated as this saves more time from Excel documents till now we have a spotfire system.

Bro i understand, pls give excel columns name I will finish

Hi, I have written a macro like this before for task manager automation. The way I accomplished that task and would wish to approach ur requirement is below: User Group 1: Presentation spreadsheet User Group 2: Presentation spreadsheet Assigner: Master Spreadsheet Additional: Database spreadsheet Master adds task to Database spreadsheet which is kept in a fixed / semifixed location. The tasks in ur case would be a row of data (simply) User group 1 and 2 using Presentation sheet pulls data from database sheet and updates the same through presentation sheets. Master has task deletion and addition rights meanwhile presentation sheets are limited to updations to data only. Technical Method: ADO/DAO Pro's: 1. Easy management 2. Backups if needed 3. No data loss. 4. No limit to presentation sheets PS: I can also complete the project for my initial ratings as a freelancer free of cost..but would like to understand the requirement of the project closely. Regards, Manpreet Juneja

Hello! I am new to Freelancer, so I don't currently have any reviews. But I would love for you to be my first client! I have a suggestion: Excel macros are often complicated and can take a long time to run (as excel is a powerful program and this creates a large overhead for computer processing). If selected, I would complete this project in Python. It is a simple programming language that can take data from excel, make any necessary transformations, and put it into the same or a different excel file MUCH faster than any program written in VBA. I actually first started learning Python after getting frustrated with how slow VBA programs were. "There must be a better way!" I thought, and there is! I have now almost 2 years of experience working with Python and Excel and automating data flow and data processing. For example, I just recently took 1000s of files from a psychology lab and transferred them into one masterfile, and the program ran in only a few seconds! I am confident that a solution to your project would be fastest in Python and I am willing to help you complete this project. I hope to hear from you soon!

I have done several project in my current and previous company. Challenges excite me. If you are not happy with my work please don't pay me. Waiting to hear from you. Relevant Skills and Experience Microsoft office, Excel macro, Excel VBA, C programming.

A proposal has not yet been provided

I deliver this project in one day. I'll go into Access to expedite the process. It can be linked or exported to excel, according to preference. The user inputs can be made simultaneously in the same file.

Honest and reliable

* Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance. * Proven background completing projects under financial and time constraints. * Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries. * Develop GUI interfaces with progress bars and status label to intimate the user about background process. * Creating Data validation on inputs to reduce the complexity and runtime errors. * Accessing and developing customized solutions for clients/users. * Designed and wrote the automation code for Excel/Outlook/Power point and Access database queries and resolution. * Creating link-based module to enable automatic updates for excel workbooks. * Designing client-specific modules for automatic reconciliation and tracking database modifications. * Designing a self-training manual for clients and users. * Designing an Algorithm and Flow charts using MS Visio wherever require (For Lengthy Projects). * Developing data validation and, input analysis programs prior to final run of process.

A proposal has not yet been provided

Sorry i can't find a flowchart diagram here. But according to the scenario provided, it's not complicated to make a macro to automate the process. My thought is below: 1. embed a macro in the spreadsheet which contains "Master Sheet". 2. Run the macro (sub 1) to extract relevant data of those 12 spreadsheets respectively to "Master Sheet". 3. 3 other groups of people provide their inputs on "Master Sheet" (perhaps this step can be done automatically too) 4. Run the macro (sub 2) to copy the updated data of "Master Sheet" to the previous 12 spreadsheets accordingly. I have several years' experience in Excel VBA. Trust me. :)