We have meetings of 5 different Groups which monitor the incomplete actions
on the database that I have set up in excel. Periodically I need to print out
lists, individual to each Group's Committee, to report which actions have not
been completed. I am going to create a macro so that I can hide/reveal
columns that I don't/do want and then I want, as I record the macro, to be
able to select just certain dates (ie certain rows) in order to produce the
report for the NEXT meeting. so I will need the date from after the previous
meeting and up to the day before the next due meeting. How do I do that? do I
use column labels or what in order to do this - can't even seem to find
instructions on how to add a column label so not getting very far and this is
moving into unfamiliar territory for me. Should I be looking at Arrays and
VLOOKUP or using Advanced Filter....?!?

I think it's a good idea to use a macro to hide the columns you don't want to
see (well, if there are more than a few and they're not contiguous).

But for the rows to see, I wouldn't use the sort and I wouldn't use a macro.

Instead, I'd just apply Data|Filter|Autofilter (xl2003 menus) and just filter to
show the rows that have dates that are greater than xxxx and less than yyyyyyyy.

You can use the dropdown arrow and select Custom to choose the values that would
produce the visible rows you want.



mkflirting wrote:

We have meetings of 5 different Groups which monitor the incomplete actions
on the database that I have set up in excel. Periodically I need to print out
lists, individual to each Group's Committee, to report which actions have not
been completed. I am going to create a macro so that I can hide/reveal
columns that I don't/do want and then I want, as I record the macro, to be
able to select just certain dates (ie certain rows) in order to produce the
report for the NEXT meeting. so I will need the date from after the previous
meeting and up to the day before the next due meeting. How do I do that? do I
use column labels or what in order to do this - can't even seem to find
instructions on how to add a column label so not getting very far and this is
moving into unfamiliar territory for me. Should I be looking at Arrays and
VLOOKUP or using Advanced Filter....?!?

--

Dave Peterson