L
lar
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.
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.