Here's my dilemma:

I have separate worksheets for different aspects of my budget (i.e.
spending money, groceries, gas, etc.) I also have a separate sheet that
shows items that have yet to clear my checking account, and this all
ties back into the main spreadsheet which shows the budget as a whole
and a bottom line of extra I have at the end of each month to put in
savings.

I have added a column to each sheet that will have a "Y" or "N" which
indicates if the charge listed in A=Merchant B= Date and C= amount
spent has cleared my account yet. If it has a "N", I would like those
3 columns (A4:C4 for example) to be copied over to the 'yet to clear'
sheet in the next blank row. Once it becomes a "Y", that row
disappears, so the remaining charges yet to clear are moved to the top
of the list.

Is this possible? Thanks in advance.

-Scott


--
darkwood
------------------------------------------------------------------------
darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948
View this thread: http://www.excelforum.com/showthread...hreadid=509218