Change the start date of each job

Lukket Lagt ut 2 år siden Betales ved levering
Lukket Betales ved levering

I am a homebuilder. I am way behind getting this to our investors. I need this done today if possible. I have a spreadsheet that is designed to allow me to look at a subdivision and create an entire proforma based on the homes I add. I have a critical fix that I need to make to the calendar, but first let me brief you on the purpose of each sheet so that you can navigate the sheet easier. This spreadsheet is made up of 4 critical Sheets:

1. "Project" Sheet: This is the summation sheet of all of the new sheets that I add.

2. "Lot-Home Attributes" Sheet: This sheet is where I assign each lot/Homesite a home. Each home as its own accompanying data. Each new home I create from the Project!I5 VB "Add New Home to Analysis" button, Automatically pulls from this sheet based on the name of the sheet that I give it. In this case I name each sheet MS1, MS2, MS3…MS64 because I have 64 lots/Homesites in this subdivision.

3. "Home Template" Sheet: This is the master template that all of the new homes are copied from when I click on the Project!I5 vb button. I have made this dynamic so that as a new sheet with the new home (MS1, MS2, MS3…MS64) is created it will draw its data via an Index(Match()) nested lookup from Lot-House attributes!A2:A67 to populate many cells from Home Template!G30:G45

4. "Homes-->" and "End" Sheets: these two sheets are just markers so that as new sheets are added, the formulas will calculate all sheets in between these two sheets. This is where MS1, MS2, MS3…MS64 will be found as they are created.

I need to take the "Home Template" sheet and I need to have the Data in E20 and the rest of the dates, dictate When the home starts so that as I add a job I will be able to see sources and uses of funds in a more realistic fashion.

The problem is this sheet was originally designed for one home. It has now been updated so that you can add as many homes as you want. I need to be able to add them and then let the schedule function be dynamic with when each job starts.. The way the "Project" sheet works, it just does a summation of all of the cells. The "Home Template" sheet is the template sheet that all new sheets pull from. So each date in cell q39 is going to be the same for each new sheet. But I need to have the data start according to what I manually put in cell E20 on the "Home Template" sheet. I need to disconnect "Home Template" sheet E20 from the Project!E23 reference and make that a manual input. I then need the Calendar fill ins that start in Column Q of the "Home Template" to start filling in the calendar starting at the date manually set at E20. HomeTemplate!Q39 will still start according to Project!E23 but as I add a new home from the Project!I5 VB "Add New Home to Analysis" I need to be able to manually insert a start date for that home and have it accurately be added to the cumulative Calendar found on Project!Q37:APU77. Right now everything starts on the same day as Project!23.

As an example of what I need: If I add a new home MS3, and I put a start date in MS3!e20 of 4-Aug-21, I would need all of the same calculations found in the Q39:APU77 fields to now start at AU39 instead of Q39. This needs to be changed at the "Home Template" sheet level.

Excel Excel VBA Excel Macros Excel VB Capabilities

Prosjekt-ID: #30487662

Om prosjektet

19 bud Eksternt prosjekt Aktiv 2 år siden

19 frilansere byr i gjennomsnitt $151 for denne jobben

sajibdigital

"Hi, I am Sajib and I am expert in excel. please consider me for this job. I will try my best for your satisfaction."

$100 USD på 7 dager
(66 Omtaler)
5.7
AccountantArman

Sir, I have understand the project. I can complete this project within minimum time possible with quality added. I am Excel Advance Level Expert. This is a basic work for me. I can complete this project with in your de Mer

$55 USD på 2 dager
(76 Omtaler)
5.3
hayteekeys

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have be Mer

$100 USD på 2 dager
(11 Omtaler)
4.4
darung

Hello. Checked Done your requirement. ================================ I am proficient for this job because I am very good at VB, Excel VBA,Form design for 7+years. First: Perfect Second:Deadline I can start immediatel Mer

$90 USD på 1 dag
(1 anmeldelse)
1.4
intells

We can assure you that we will submit your task within the stipulated time with quality work. We have expert engineers working within our organization whose prefered fields get along with your desires. We can certain Mer

$190 USD på 7 dager
(0 Omtaler)
0.0
mohitsolanki679

Hello, We are team of experienced and professional developers and designers. We believe in deliver best quality product to our clients. I'm new to this platform, otherwise i have plenty of experience in this industry. Mer

$140 USD på 7 dager
(0 Omtaler)
0.0
anpilogovfree

Hello! As a VB expert, I can complete your project successfully. Well familiar with VBA macros, I can update your macro on time. Looking forward to working with you for a long time. Best regards

$250 USD på 2 dager
(0 Omtaler)
0.0
PravinKumarpasw1

Very good data entry jobs in Mumbai to work with the very help I really appreciate it I will have to work on it and PAN to I am CITS pass it.

$140 USD på 7 dager
(0 Omtaler)
0.0
samsongonmei8

No doubt, your work is complicated. Let me do it. Pay me as expected. Let's keept in touch for nonmistake

$250 USD på 7 dager
(0 Omtaler)
0.0
pipi1702

Hi this is pipi1702 from freelancer I am professional data entry operator I assure you I will complete the project before the deadline with 100 percent accuracy.

$30 USD på 4 dager
(0 Omtaler)
0.0
sukhadiyadeepak

Hello Sir I am deepak Kumar My work data entry Your request 7day complete at me Thank you Deepak kumar Regards

$140 USD på 7 dager
(0 Omtaler)
0.0