only cells that are colored yellow

[childothe1980s]

Hello:

Because I cannot find any other way to handle it, I am having to copy and
paste two columns of account numbers and dollar amounts from one spreadsheet
tab to another spreadsheet tab within the same book.

The tab that I am copying from has a bunch of other meaningless data (at
least it's "meaningless" to me).

Anyway, the only distinguishing feature of these two columns is that they
are color-coded yellow.

Is there any sort of formula or macro or whatever that would allow me to
automatically copy this data rather than manual copy and paste. This is
taking me hours to do.

Thanks!

childofthe1980s

[crazybass2]

Is it always the same two columns?

"childothe1980s" wrote:

> Hello:
>
> Because I cannot find any other way to handle it, I am having to copy and
> paste two columns of account numbers and dollar amounts from one spreadsheet
> tab to another spreadsheet tab within the same book.
>
> The tab that I am copying from has a bunch of other meaningless data (at
> least it's "meaningless" to me).
>
> Anyway, the only distinguishing feature of these two columns is that they
> are color-coded yellow.
>
> Is there any sort of formula or macro or whatever that would allow me to
> automatically copy this data rather than manual copy and paste. This is
> taking me hours to do.
>
> Thanks!
>
> childofthe1980s