Why a Marco? Why not just set up your sheet:

Customer Date Amount Current 30 60 90

Then use if formulas in the 30 60 and 90 columns to get the value out of the
amount column if appropriate. It is a whole pile easier than a macro...

For the 30 day column...
=if(and (b2=date() + 30, b2<date()+60)), C2, "")
or something like that (untested formula).
HTH

"Dennis Merchand" wrote:

I want an excel accounts receivable file to moove receivables to the
appropiate age column as they get olde. For example, if item is 30 days old,
it should automatically move into the 30 day column.