I've read some of the existing questions/answers ..... and I'd like to ask.....

I'm using Excel 2002/XP. I currently have one file (Task List) with 6
worksheets (Areas of Responsibility) and four columns (Name, What, Start
Date, Deadline). Each row is a different task.

I would like to be able to retrieve my file and request that it gives me a
new screen with all the tasks with a deadline of a specific date.

Can this be done? If yes, how?
I'm relatively new to Excel and do not know much about visual basic codes.

Any help would be appreciated. Thanks.

--
Diane

Diane,

Your current spreadsheet architecture makes that difficult.

Instead, insert a new sheet, and on that sheet make 5 columns: Areas of
Responsibility, Name, What, Start Date, Deadline.

Then copy the tables from the 6 worksheets into the last four columns, one
below the other. In the first column, enter the name of the worksheet from
which you copied each section.

Do that for all 6 worksheets, then delete the original worksheets.

You will then have a database, and you can apply data filters to it, and
view your data any way you want, such as by deadlines of a specific date,
simply by selecting your table, then using Data | Filter... Autofilter.

HTH,
Bernie
MS Excel MVP


"DianeMcP" wrote in message
...
I've read some of the existing questions/answers ..... and I'd like to
ask.....

I'm using Excel 2002/XP. I currently have one file (Task List) with 6
worksheets (Areas of Responsibility) and four columns (Name, What, Start
Date, Deadline). Each row is a different task.

I would like to be able to retrieve my file and request that it gives me a
new screen with all the tasks with a deadline of a specific date.

Can this be done? If yes, how?
I'm relatively new to Excel and do not know much about visual basic codes.

Any help would be appreciated. Thanks.

--
Diane

Hi Bernie,

Thanks very much for your reply.

I did want you suggested and I don't really have to apply any Data |
Filters, because sorting by Dates will also give me all the items required by
the same day. Sorting doesn't give me a separate screen/worksheet that lists
any one date, but it will arrange my list so that the dates are listed
together.

I haven't been able to understand the language/coding required for applying
filters. If I did, however, want a report/sheet with only a specific date,
what would I have to put and where?

Is there a listing somewhere of codes/syntax to be used .... hopefully with
some sample data sheets and sample reports?

--
Thanks,
Diane


"Bernie Deitrick" wrote:

Diane,

Your current spreadsheet architecture makes that difficult.

Instead, insert a new sheet, and on that sheet make 5 columns: Areas of
Responsibility, Name, What, Start Date, Deadline.

Then copy the tables from the 6 worksheets into the last four columns, one
below the other. In the first column, enter the name of the worksheet from
which you copied each section.

Do that for all 6 worksheets, then delete the original worksheets.

You will then have a database, and you can apply data filters to it, and
view your data any way you want, such as by deadlines of a specific date,
simply by selecting your table, then using Data | Filter... Autofilter.

HTH,
Bernie
MS Excel MVP


"DianeMcP" wrote in message
...
I've read some of the existing questions/answers ..... and I'd like to
ask.....

I'm using Excel 2002/XP. I currently have one file (Task List) with 6
worksheets (Areas of Responsibility) and four columns (Name, What, Start
Date, Deadline). Each row is a different task.

I would like to be able to retrieve my file and request that it gives me a
new screen with all the tasks with a deadline of a specific date.

Can this be done? If yes, how?
I'm relatively new to Excel and do not know much about visual basic codes.

Any help would be appreciated. Thanks.

--
Diane

... If I did, however, want a report / sheet
with only a specific date,
what would I have to put and where?

One play which would deliver this ..

Assume the source data is now in Sheet1, cols A to D*, data from row2 down,
with the key col = col D ("DeadLine")
*Name, What, StartDate, DeadLine

Assuming 2 empty cols to the right, cols E & F

Put in F1: =IF(Sheet2!A1="","",Sheet2!A1)

Put in E2: =IF(D2="","",IF(D2=$F$1,ROW(),""))

Copy E2 down to say, E100
to cover the max expected data range in cols A to D

(Leave E1 empty)

In Sheet2
----------
A1 will be reserved for input of the deadline of interest
Input a date into A1, say: 01-Jul-2005

Paste the same col headers into A2:D2, viz.:
Name, What, StartDate, DeadLine

Put in A3:

=IF(ISERROR(SMALL(Sheet1!$E:$E,ROWS($A$1:A1))),"", INDEX(Sheet1!A:A,MATCH(SMA
LL(Sheet1!$E:$E,ROWS($A$1:A1)),Sheet1!$E:$E,0)))

Copy A3 across to D3, fill down to D101
(cover the same range as in col E in Sheet1)

Format cols C and D as dates

Sheet 2 will auto-extract only the rows from Sheet1 where the deadlines are
equal to the date input in A1. These will be bunched neatly at the top, with
blank rows below.

Adapt to suit ..

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Hi Max,

I've put all the coding in my columns, but how do I tell it to do the
extraction.
I've checked all the coding (and see that some of it changes based on the
column that it's in - nice to see that happen automatically). Is there a
button to press or pull-down command?
--
Thanks,
Diane

Update: I went back and noticed that the equal sign was missing from your
first command for F1. When not in those columns, there are numbers showing
up in them. In F1, I have "38520" showing. In F2, the number 2; in F6, the
number 6, and in F7, the number 7. Is this normal? What are they related to?
--
Thanks,
Diane


"DianeMcP" wrote:

Hi Max,

I've put all the coding in my columns, but how do I tell it to do the
extraction.
I've checked all the coding (and see that some of it changes based on the
column that it's in - nice to see that happen automatically). Is there a
button to press or pull-down command?
--
Thanks,
Diane

Hope you can help. I'm trying to enter a formula to calculate year to date
variance from 2004-2005. Data for '04' is on another worksheet. How do I
enter the formula
I'm using Excel 2003.

Thanks
"DianeMcP" wrote:

I've read some of the existing questions/answers ..... and I'd like to ask.....

I'm using Excel 2002/XP. I currently have one file (Task List) with 6
worksheets (Areas of Responsibility) and four columns (Name, What, Start
Date, Deadline). Each row is a different task.

I would like to be able to retrieve my file and request that it gives me a
new screen with all the tasks with a deadline of a specific date.

Can this be done? If yes, how?
I'm relatively new to Excel and do not know much about visual basic codes.

Any help would be appreciated. Thanks.

--
Diane

"sheri" wrote in message
...
Hope you can help. I'm trying to enter a formula to calculate year to date
variance from 2004-2005. Data for '04' is on another worksheet. How do I
enter the formula
I'm using Excel 2003.


In the cell you want the variance to appear, type "+" (without the quotes),
then click on the Year to Date total on the 05 sheet, then type "-" (again
without the quotes), then click on the 04 sheet tab, and click on the 04 YTD
total cell. Hit "enter". Job done!