(1) I have recorded a macro that cleans up exported reports & puts it
into a format that I need. The final result of this macro is a
worksheet that all the data that I need including $ amounts is
formatted correctly & a preceding column that indicates if the $ amount
is over a predefined amount.

What I need is a macro that will look at the "under/over" column & Cut
& Pastes all the "over" $ amounts data into another worksheet.

So in the end, I have an "Under" & an "Over" worksheet where the $
amounts & corressponding data are seperated by the predefined $ limit.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements