Transfer weekly columns into daily rows

[Calcsforus]

The attached cash budget was set up in a weekly format, but I prefer to work with a daily format. How do I get the information on the "2019" tab to pull into the "Daily Cash Flow" tab? I added the "Category" column in the "2019" tab thinking that this could help. So far, I've tried Sumifs and Sumproduct.

[dosydos]

You could use Hlookups() or possibly even Index match match formulas. My question to you is, you gave us weekly data (revenue etccc.). How do you plan on allocating it to daily?

[Calcsforus]

I want the budgeted amounts to drop in each Monday on the daily tab. The budgeted amounts will be changed to daily actuals throughout the year.

[Pete_UK]

Do you want to show the daily amounts as 1/7th of the weekly amounts found? I think that would be easier, in copying a formula down, than to have 6 blank rows and a filled row only where the date is a Monday.

Your budgeted amounts start on 21st October in column C of the 2019 sheet, but your start date in the daily sheet is 30th October - wouldn't it be better to make these the same?

Hope this helps.

Pete

[Calcsforus]

Thank you for your information. This is not my actual budget worksheet, so the dates are not important. I was hoping that someone could just help me with a formula that will do what needs to be done. I am ok with having the daily amounts as 1/7 of the weekly amounts, although I believe this would complicate the matter. My idea was that I would filter out all other days of the week before copying the formula down.

[Pete_UK]

OK, put this formula in cell A3 of the Daily sheet:

='2019'!$C$1

and this one in A4:

=A3+1

Copy this down to A74. Then you can use this formula in B3:

=IFERROR(SUMIFS(INDEX('2019'!$C:$L,0,MATCH($A3,'2019'!$C$1:$L$1,0)),'2019'!$B:$B,B$2),"")

Copy this across and down as required.

Hope this helps.

Pete

[Calcsforus]

Thanks so much! That works beautifully!

[Pete_UK]

You're welcome, and thanks for marking the thread as Solved.

You might also like to know that you can show your appreciation directly and thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete