Extracting dates

T

Tom Brown

I have a Workbook with three sheets. Each sheet has 5 columns with various
dates in them. The dates are associated with To Do tasks. Each column has
about 11 dates/tasks .. listed chronologically. The dates in each column
are staggered slightly (chronologically). So, each sheet has 55 dates and
each workbook has a total of 165 (55x3) dates. That's a lot to keep
straight in one's head.

I need to be able to extract a report that lists the associated tasks in
total chronological order for all 165 dates. I would like to be able to do
this from both the Excel workbook and also (hopefully) from a related Access
database command button.

Is this something that can be done easily or am I looking at a major
project?

TIA,

Tom
 
T

Tom Brown

Actually, to further clarify, I would need to extract the dates for a
specified time ... like "tasks" from Today through the next 30 days.

Thanks,

Tom
 
T

Tom Brown

I didn't get any responses to my initial request for information so maybe
now I should just ask for a hint on what help section to go to. Really, I
haven't got a clue so any assistance is appreciated.

TIA,

Tom
 
R

Roger Govier

Hi Tom

Personally I would copy all the data from the 3 sheets to a single sheet,
with an extra column designating which sheet they came from, or the name of
the Sheet if they are different departments etc. This would involve a simple
copy and paste operation one off. Then stick with a single sheet for all
data, and Filter your requirements as below.

Then with all the data on one sheet, and assuming you have a header in row
1, mark the headers and Data>Filter>Autofilter
Use the Dropdown on the Date column to select with Custom the earliest and
latest dates you require, and you will have a list just applicable to those
dates.

Use the Dropdown for Sheet(Department) to filter and show just the
individual department if required.

Regards

Roger Govier
 
T

Tom Brown

Roger, thanks for the reply. Unfortunately, it doesn't nail my real
question.

Allow me to try to clarify and simplify the question. Assume 1 sheet. I
have 11 tasks that repeats 4 times per year. Let's assume I have one sheet
with 5 columns. We can focus on the first task only. The first column is
the list of tasks. The next 4 columns is the dates for each one of these
tasks. As I said, they overlap. In other words, Task 1 (row 1, column 1)
will recur 4 times over the year (dates in row 1, columns 2,3,4). My
problem/question is ... how do I sort the list of dates into a report based
on all four columns? 11 tasks with 44 dates (or, to simplify, 1 task with 4
dates). I need to sort all of them by date (but sort all 4 date columns as
if they were 1 column).

Thanks in advance,

Tom
 
R

Roger Govier

Hi Tom

Sorry, but I can't quite visualise the problem. If you want to mail me an
example I will take a look for you. Remove NOSPAM from my address to send
direct.

Regards

Roger Govier
 
T

Tom Brown

Thanks Roger. Done.

Tom

Roger Govier said:
Hi Tom

Sorry, but I can't quite visualise the problem. If you want to mail me an
example I will take a look for you. Remove NOSPAM from my address to send
direct.

Regards

Roger Govier
Click to expand...
 
Top