macro related
 

i have a worksheet of Good receipts in which i have to do ageing of various
items in following manner - 90 days,90 to 180 days, 180 to 365 days, above
365 days. Then i have to do sorting & thereafter subtotal.

i have to prepare this report on monthly basis......i can set the macro but
main problem is that no of rows in a worksheet are not same, sometimes it may
be less or it may be more.

any solution to this???

Why not use a formula in another column

=IF(A1TODAY()-90,1,IF(A1TODAY()-180,2,IF(A1TODAY()-365,3,4)))

and then drop it into a pivot table for analysis using that new column as a
grouping factor

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ankur" wrote in message
...
i have a worksheet of Good receipts in which i have to do ageing of
various
items in following manner - 90 days,90 to 180 days, 180 to 365 days, above
365 days. Then i have to do sorting & thereafter subtotal.

i have to prepare this report on monthly basis......i can set the macro
but
main problem is that no of rows in a worksheet are not same, sometimes it
may
be less or it may be more.

any solution to this???

thanks bob for your response.

is it possible that instead of today i put some particluar date in that
formula, i tried but was not successful.

"Bob Phillips" wrote:

Why not use a formula in another column

=IF(A1TODAY()-90,1,IF(A1TODAY()-180,2,IF(A1TODAY()-365,3,4)))

and then drop it into a pivot table for analysis using that new column as a
grouping factor

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ankur" wrote in message
...
i have a worksheet of Good receipts in which i have to do ageing of
various
items in following manner - 90 days,90 to 180 days, 180 to 365 days, above
365 days. Then i have to do sorting & thereafter subtotal.

i have to prepare this report on monthly basis......i can set the macro
but
main problem is that no of rows in a worksheet are not same, sometimes it
may
be less or it may be more.

any solution to this???

Yes. try:

=IF(A1DATE(2005,8,17)-90,1,IF(A1DATE(2005,8,17)-180,2,IF(A1DATE(2005,8,17
)-365,3,4)))

for todays date.


Mangesh



"Ankur" wrote in message
...
thanks bob for your response.

is it possible that instead of today i put some particluar date in that
formula, i tried but was not successful.

"Bob Phillips" wrote:

Why not use a formula in another column

=IF(A1TODAY()-90,1,IF(A1TODAY()-180,2,IF(A1TODAY()-365,3,4)))

and then drop it into a pivot table for analysis using that new column
as a
grouping factor

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ankur" wrote in message
...
i have a worksheet of Good receipts in which i have to do ageing of
various
items in following manner - 90 days,90 to 180 days, 180 to 365 days,
above
365 days. Then i have to do sorting & thereafter subtotal.

i have to prepare this report on monthly basis......i can set the
macro
but
main problem is that no of rows in a worksheet are not same, sometimes
it
may
be less or it may be more.

any solution to this???