Yes, all of this should be doable. However, it sounds like you might like
professional help.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Big UT Fan" wrote in message
...
Some things I'd like to be able to do. I'm willing to do the research and
implement these if I know these are doable in Excel. Here's what I'd like
to
do:

1) Have new data (rows) automatically sorted when added to a worksheet.

2) When a monthly "update" is performed, "archive" old data (move no
longer
needed rows to a diff worksheet).

3) Perform actions on this data (rows) based on additional data. The
number
of rows will determine how many rows are used in the "update". For
example,
if there were 5-6 rows of data use only 1 of the rows for the update. 6-7
rows of data, use 2 rows, and so on.

4) I'd like to peform the "update" based on specific monthly dates or by
hand as required. Being able to "run" the update on the spreadsheet and
have
some output produced such as an email sent would be great.

The help of the community here is always appreciated.

Thanks, Mike