Other than the colored rows there must be another method of defining the 4
accounts.

Have you tried DataFilterAutofilter on account names or account numbers?

You can then copy the visible rows to another sheet.


Gord Dibben MS Excel MVP

On Sun, 17 Feb 2008 15:52:00 -0800, Shaz wrote:

I am trying to set up a running total of expenses etc, where my first sheet
is a combined running totals, from 4 different accounts, so the rows are
colour coded accordingly. I then have monthly sheets, where I want to break
down of the running totals according to the account.

PROBLEM -

Is there anyway of copying only certain rows, such as, all the blue text
rows, or the red text rows? I have tried to select the relevant rows, by
pressing control and the relevant coloured text for each bank account, but
when it comes to copying, it will not allow my to copy multiple rows.
Copying each individual row is WAY too tedious, there must be a quicker way!
I even tried hiding the colours I didn't want, but when I press copy, it
copies the whole lot across, not just the visible colour!

Does this make sense, or am I trying to make my life way too complicated??????

My aim is to have a running total on the one sheet, and then I can also
check on the individual movements of account transactions and see the
balance, if that makes sense??