Organizing tasks and schedules with forulas


New Member
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:
task 1
task 2
task 3
proj 2
task 1
task 2
task 3
and so on
and so on


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

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.:confused:


Well-known Member

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

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Syntax errors
    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: [code=rich]Syntax Error: Function...