New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Using Fromula to move rows

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Using Fromula to move rows

Postby Kello » Thu Mar 10, 2016 12:03 pm

Hello,
I am stuck on an issue and looking for some help. I am using excel to track task from "Date started" to "Date completed" as well as other data needed about each task. Each month of the year having its own sheet. I am trying to find a way to flag task that have a start date but no complete date across the whole year and list each tasks information on a different sheet , like a "to be don list".
Is this possible?
  • 0

Kello
Rookie
 
Posts: 1
Joined: Mar 10, 2016
Reputation: 0
Excel Version: 2010

Re: Using Fromula to move rows

Postby pecoflyer » Thu Mar 10, 2016 12:12 pm

Hi and welcome

do you absolutely need one sheet per month?

The easiest way is to concentrate all on one sheet from which monthly data can be extracted.

Could you consider doing this?
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 120 guests