Create version control in Excel (Excel)
I have a large table of projects, subprojects and products that relate to them.
Once a week, I do a download of this document from the CRM system. Sometimes prices, calls, status of some products change or new projects are added to the table.
I have to monitor the changes and write in, let’s say, the mother’s Excel, what the key actions on the projects (re-call this project to such that date for example).
Today I don’t see how to organize such a control – technically. This competence is missing.
You could show me to do a lesson hardly speaking about this story if you have an understanding of how it could be implemented at the Excel level. Do this with the files I’ll send you, let’s say three to demonstrate the work.. ?
My task is to be able to do it on my own.
-
1 day11 USD
119 1 0 1 day11 USD
Good day ! Give examples of files. I offer you to connect through remote access and I will show you everything clearly.
-
1 day11 USD
5178 210 0 1 day11 USD
Good day . Maybe I can help you. Can you send the test files?
-
1 day11 USD
661 38 2 1 day11 USD
You need to look at the files and in accordance with what in these files will be - to clarify what specifically you want.
To track the changes, obviously, you will need to fix the previous loads to compare with the subsequent loads if necessary. The comparison of the versions of loads will likely have to be done by VBA macros, which will compare and report the difference between loads.
The price/term is conditional, you have to look at what there is behind the files and then the volume of work will be understood.
Current freelance projects in the category Data Processing
Building financial models (P&L + Cash Flow)We are looking for a qualified specialist who can help organize our business finances. We need to develop and implement two key reporting forms: P&L (profit and loss statement) and Cash Flow (cash flow statement). Please provide your work experience, what you have worked on,… Accounting Services, Data Processing ∙ 1 day 1 hour back ∙ 15 proposals |
Assistant to the manager for project work in the field of science and scientific publicationsLooking for a responsible assistant to work with personal social networks, a contact database, and current projects in the field of science and scientific publications. At the first stage, the collaboration is planned for one month. The main task is to assist with basic… Information Gathering, Data Processing ∙ 1 day 17 hours back ∙ 8 proposals |
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 3 days 16 hours back ∙ 20 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 3 days 17 hours back ∙ 19 proposals |
Search for manufacturer / contract manufacturing Ukraine
22 USD
Need to find 3 contract manufacturers of dietary supplements in the form of gummy candies in Ukraine or nearby countries (Hungary, Poland), and inquire about the terms of cooperation: - minimum order (price) - price for increased volume - number of functions they can produce?… Marketing Research, Data Processing ∙ 6 days 2 hours back ∙ 11 proposals |
France