Organization of dynamic linking in Excel between sheets

Budget: 700 UAH Deadline: 1 day

Good day. I understood the task. I have the 2016 version. I will be happy to cooperate.

Budget: 700 UAH Deadline: 5 days

Hello! I will be happy to complete your task :)
I have practical skills in working with Excel and logic between sheets.
The task is clear to me: it is necessary for the data entered on the JOBS sheet to be saved in DATA, and also to be loaded back when selecting a date. All this considering the dynamic number of teams and the structure of the calendar.
I will implement it through macros (VBA), and if needed, I will adapt it for Google Sheets.

Budget: 700 UAH Deadline: 1 day

Good day. This task is performed using simple formulas. I would recommend expanding the table. That way it would be more readable.

Budget: 700 UAH Deadline: 1 day

I can do it, although for a more accurate assessment I would like to see the actual file instead of screenshots. There is a possibility to work in Excel 2010.

Budget: 2000 UAH Deadline: 3 days

Good day!

I understand that it is necessary to set up the logic between the JOBS and DATA sheets: entering data for crews on one sheet, automatically saving it in a structured form on another, and also loading this data back when selecting a date in the calendar.

Approach to implementation:

I will do this through VBA macros and formulas:
1. On the JOBS sheet, I will set up a change handler in the crew range: as soon as you enter a value (for the selected date) – it will be recorded in DATA in the form of a record "date – crew – resource – value";
2. When the date changes on JOBS, the macro will search for the corresponding records in DATA and fill in the table for the selected date;
3. I will implement a check: if no date is selected – the entered values will not be saved;
4. On DATA, I will set up formulas for "Planned quantity," "Actually completed," "Difference plan/fact," total for the week, and other summary columns considering the structure of your table;
5. I will write the logic so that the number of crews and job names can be flexibly changed.

Estimated cost: from 2000 to 2800 UAH (depending on final requirements and the volume of adjustments),
Timeline: 1–2 working days after agreeing on the details and receiving the file in a working format.

I will be able to provide the exact amount after answers to the questions below:

1. Can we rely on supporting Excel versions 2016 and above, or is it necessary to maintain compatibility with 2010?
2. Is the structure of the DATA sheet already final, or are you willing to change it a bit if it simplifies the logic and increases stability?
3. How exactly should the record in DATA look: one cell for "date–crew–resource" or is an intermediate "database" (list of records in rows) acceptable?
4. Will the crews change during the project (be added/renamed), and should the history of old names be preserved?
5. Is a separate protection against accidental deletion/modification of formulas on the DATA sheet needed (locking ranges, simple checks, etc.)?
6. Is there a plan for future expansion of the file (new types of work, additional reports) to lay down a flexible structure from the start? Expand

Budget: 800 UAH Deadline: 2 days

Good day. I will help to complete. Skills and experience are professional. I will offer an optimal solution. Please contact me.

Budget: 700 UAH Deadline: 2 days

Good day.
I have experience in writing macros for Excel.
Let's discuss the details.

Budget: 700 UAH Deadline: 1 day

Hello!
It seems that the task is clear, but I would like to clarify some details) I am ready to complete such a task. One of the suggestions is to work on Google Sheets and not worry about Excel versions) I am stating the price arbitrarily because I would like to clarify the project specifications a bit.

Budget: 700 UAH Deadline: 1 day

I am ready to promptly and qualitatively complete your order. I have experience working with similar projects, always adhere to deadlines and technical specifications. I will be happy to collaborate!

Budget: 700 UAH Deadline: 1 day

Good day. I will be happy to help. I will complete everything quickly and efficiently!

Budget: 700 UAH Deadline: 1 day

Hello.
I have extensive experience working with Google Sheets and Excel.
I also create scripts for the aforementioned programs.

Check out my portfolio and reviews.
Freelancehunt

I have familiarized myself with the project. I am ready to help with the implementation.
Write to me - we will discuss the details.

Budget: 2000 UAH Deadline: 1 day

Good day! I have a very large experience in working with ET Excel, so I will complete the task you set with quality!!!!!!!!! Feel free to contact me!!!!