only cells that are colored yellow
 

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

only cells that are colored yellow
 

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