I want to automate "materials by month" and "materials by task" into a "materials by month and task" table by formula

Liero131313

New Member
Joined
Jun 9, 2023
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello,

Thank you very much for reading this.

Say I have some lumber costs. And I can say "It'll take $2000", split this way between task 4 and 5 and I can tell it will be $500 per month from months 4 to 7"

I can take this small example and eventually come to the bottom distribution at the end of the screenshot, where the costs zigzag down, drawing down the first task by that month then when it runs out, go to the next task.

This requires both tables to have the same sum for Material 1 to work. It feels like there's a formula that can take any 2 tables as input and do this "Gantt charting" zigzag, but I don't know how.

I want to layer in multiple materials to the same table, so I can put a filter on it and you can just see it show the costs over time and task. Any help would be appreciated.
1686334920846.png
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,223,889
Messages
6,175,223
Members
452,620
Latest member
dsubash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top