B
Big UT Fan
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
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