Help with formula to put data in next available cell

[jmcole]

The cells auto populate depending on the date, the day of the week, the fiscal year month, etc. Instead of putting formulas in each cell, can I add all of the formulas together into one cell and if that cell already has data in it, put the data into the next cell?

[Pepe Le Mokko]

Without VBA you cannot do that

[JohnTopley]

The attached is a partial solution in that the formula will gather data for one day. Note that I changed your Data table to make Fri, Sat, Sun as separate entries.

If you had separate tables for Weekly/Monthly then you could use the same formula, changing the day selection to weekly/ monthly.

If you need more than this, then as previously stated, you will need VBA

[jmcole]

Thanks for the help, I might have to go the VBA route.