Prev: Conditional Formatting: Fill Cell if Formula Overwritten
Next: Footer date format
From: mkflirting on 14 Apr 2010 10:13
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....?!?
From: Dave Peterson on 14 Apr 2010 13:27
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
 | 
Pages: 1
Prev: Conditional Formatting: Fill Cell if Formula Overwritten
Next: Footer date format