Macros in EXCEL

[Guest]

I have created an EXCEL spreadsheet that has 100 rows of data across four
columns. I have created some basic MACROS to avoid future entering of the
same/similar data. THE POBLEM: I want to create a MACRO where the data can
be selected based on a range of data: ex. if the age is > 10 and < 40 and in
the month/day range of Oct. 1 thru Oct. 10, 2004 then select the data and
create a chart. Does CUSTOM Macro allow for Range selection or can I do this
selection in a simple easy to code Macro. OR, must VBA be used in this case
(I do not know VBA). Thus am I finished and at a loss. APPRECIATE all
replies. Thank You.

 

[Gord Dibben]

lar

Macros are VBA so you're using VBA now if you are creating/using macros.

Data Filtering would seem to the resolution for you.

Either AutoFilter or Advanced Filter.

See Debra Dalgleish's site for more info on this.

http://www.contextures.on.ca/tiptech.html

Look under the "A" section for Advanced and Auto filtering.

Gord Dibben Excel MVP