H
Hile
OS: Win2k Pro SP4
App: xls 2003 SP2
I have a problem that appears to extend beyond my skills. I have a
Production List, it has a list of recurring reports produced out of the
department. In here I have 2 columns that show me whether the due date (col
F) is a calendar day or work day or weekday, etc, and the second column (col
G) shows me the actual "date" (be it 1, 2, 3, Monday, etc.; it may have
negative numbers if the due date is +/- x number of days from Last Work Day
which is also a parameter in col F).
I created a grid Col X has a list of unique records from Col G (actual date)
and Row 2 has a list of unique records from Col F (date parameter). I now
want to count how many reports I have each due date for the specific
parameter. My grid looks like this:
CD WD LWD DAY As Required
-1
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
25
1-30
15-30
Dynamic
Monday
Tuesday
Wednesday
Thursday
Friday
Week1
I tried to use Index/Match combo but couldn't figure out how to plug in the
actual countif (well I tried countif aone first and it just didn't work for
some reason, it gave me all zeros); plus I will like to make grid row/col
dynamic as the file changes so I don't have to keep renewing and repopulating
the formula on the grid. I will like the formula(s) or VBA code to use a
match type function to find the location of the data currently in columns F
and G in case additional columns are ever added to this spreadsheet.
Unfortunately since our job is to provide the field with what they need I
can't standardizee the data in Col F & G, that's why I need to keep filtering
for unique records depending on what we've entered there. I try to keep it as
standard as I can. Col F title is "Req Date Parameter" and Col G is "Actual
Due Date"
I hope someone can help me because I really need to use this data for
workflow, resource allocation, business planning, risk assessment, business
continuity, and identifying capacity issues so I'm constantly recalculating
stuff. This will take half the work off it. I WOULD REALLY appreciate any
help with any piece of this puzzle. I will be happy to provide a sample file
to anyone. My VBA is very limited, so if you are going to suggest VBA please
provide any help/direction/code you can.
THANKS!
App: xls 2003 SP2
I have a problem that appears to extend beyond my skills. I have a
Production List, it has a list of recurring reports produced out of the
department. In here I have 2 columns that show me whether the due date (col
F) is a calendar day or work day or weekday, etc, and the second column (col
G) shows me the actual "date" (be it 1, 2, 3, Monday, etc.; it may have
negative numbers if the due date is +/- x number of days from Last Work Day
which is also a parameter in col F).
I created a grid Col X has a list of unique records from Col G (actual date)
and Row 2 has a list of unique records from Col F (date parameter). I now
want to count how many reports I have each due date for the specific
parameter. My grid looks like this:
CD WD LWD DAY As Required
-1
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
25
1-30
15-30
Dynamic
Monday
Tuesday
Wednesday
Thursday
Friday
Week1
I tried to use Index/Match combo but couldn't figure out how to plug in the
actual countif (well I tried countif aone first and it just didn't work for
some reason, it gave me all zeros); plus I will like to make grid row/col
dynamic as the file changes so I don't have to keep renewing and repopulating
the formula on the grid. I will like the formula(s) or VBA code to use a
match type function to find the location of the data currently in columns F
and G in case additional columns are ever added to this spreadsheet.
Unfortunately since our job is to provide the field with what they need I
can't standardizee the data in Col F & G, that's why I need to keep filtering
for unique records depending on what we've entered there. I try to keep it as
standard as I can. Col F title is "Req Date Parameter" and Col G is "Actual
Due Date"
I hope someone can help me because I really need to use this data for
workflow, resource allocation, business planning, risk assessment, business
continuity, and identifying capacity issues so I'm constantly recalculating
stuff. This will take half the work off it. I WOULD REALLY appreciate any
help with any piece of this puzzle. I will be happy to provide a sample file
to anyone. My VBA is very limited, so if you are going to suggest VBA please
provide any help/direction/code you can.
THANKS!