Organizing tasks and schedules with forulas

[MrMeeseeks]

Hello everyone,

I am trying to make a spreadsheet that includes a calendar for task scheduling and the project details in another tab.

Columns B and C in the calendar look something like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[/TR]
[TR]
[TD]proj.1
[/TD]
[TD]task 1
[/TD]
[/TR]
[TR]
[TD](blank)
[/TD]
[TD]task 2
[/TD]
[/TR]
[TR]
[TD](blank)
[/TD]
[TD]task 3
[/TD]
[/TR]
[TR]
[TD]proj 2
[/TD]
[TD]task 1
[/TD]
[/TR]
[TR]
[TD](blank)
[/TD]
[TD]task 2
[/TD]
[/TR]
[TR]
[TD](blank)
[/TD]
[TD]task 3
[/TD]
[/TR]
[TR]
[TD]and so on
[/TD]
[TD]and so on
[/TD]
[/TR]
</tbody>[/TABLE]

Now i need to generate the list for the project details in another tab using formulas so that who'll be using this sheet won't have to update both tabs every time (minimizing the human error).

In short: the list should take the data from column B and display it in the same order in a chosen column, like this:

proj 1
proj2
proj3
etc

but i cannot find a way to skip the blank cells and only display the ones that have content.

So far i tried using IFs, ISBLANKs, VLOOKUPs and combinations of those + others, with no luck so far.

I am starting to think that this might be very complicated if not impossible. Do you think that writing a (not too complicated) macro would be better? Or maybe with "define name" or making a data set of the column i need the info from might work?

Iknow, i know, there are softwares and apps that do exactly what i need which i already tried and proposed, but you know how it is... If the boss needs a wheel but wants it to be a square but equally functional you have to do your best to comply.

 

[RasGhul]

Hi,

So how many days do you need to show tasks on the calendar tab? a chosen week or fortnight?