Transferring contents and color of cell
 

Is there an easy way of not only transferring the contents of a cell to
another sheet within a workbook (which I do with an equation) but also the
fill color of the cell. Right now I use an Indirect statement to get this
done. I have 10 sheets (Sheet1 to Sheet10) which contain columns of data
that may be different colors depending on the conditional statements. I
also have one summary sheet which will list all the data from the 10 sheets.
I prefer not to put the conditional statements into my summary page as well
and is why I am hoping there is a way.

Thank you in advance,

Les

Transferring contents and color of cell
 

Formulas return values to the cells with the formula. They don't return
formatting.

You could copy and paste special|Formats or have a macro do this for you if you
want--just record a macro when you do it once manually and you'll have your
code.

Les wrote:

Is there an easy way of not only transferring the contents of a cell to
another sheet within a workbook (which I do with an equation) but also the
fill color of the cell. Right now I use an Indirect statement to get this
done. I have 10 sheets (Sheet1 to Sheet10) which contain columns of data
that may be different colors depending on the conditional statements. I
also have one summary sheet which will list all the data from the 10 sheets.
I prefer not to put the conditional statements into my summary page as well
and is why I am hoping there is a way.

Thank you in advance,

Les

--

Dave Peterson

Transferring contents and color of cell
 

Hi Dave,

Yes I understand what you say that formulas return values. I do not want to
consider a macro since I want this to be an automatic method. If that is
the only way to do it then I have no choice but to use conditional
formatting on my summary sheet just like I use on the other 10 sheets.

Thank you very much for trying to help Dave I appreciate it,

Les

"Dave Peterson" wrote in message
...
Formulas return values to the cells with the formula. They don't return
formatting.

You could copy and paste special|Formats or have a macro do this for you
if you
want--just record a macro when you do it once manually and you'll have
your
code.

Les wrote:

Is there an easy way of not only transferring the contents of a cell to
another sheet within a workbook (which I do with an equation) but also
the
fill color of the cell. Right now I use an Indirect statement to get
this
done. I have 10 sheets (Sheet1 to Sheet10) which contain columns of
data
that may be different colors depending on the conditional statements. I
also have one summary sheet which will list all the data from the 10
sheets.
I prefer not to put the conditional statements into my summary page as
well
and is why I am hoping there is a way.

Thank you in advance,

Les

--

Dave Peterson

Transferring contents and color of cell
 

Sometimes, you can use macros that look very automatic.

Depending on how the other cells change, you might be able to use one of the
worksheet_change events to do the copy|pasting.

You can read more about events at:
Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Les wrote:

Hi Dave,

Yes I understand what you say that formulas return values. I do not want to
consider a macro since I want this to be an automatic method. If that is
the only way to do it then I have no choice but to use conditional
formatting on my summary sheet just like I use on the other 10 sheets.

Thank you very much for trying to help Dave I appreciate it,

Les

"Dave Peterson" wrote in message
...
Formulas return values to the cells with the formula. They don't return
formatting.

You could copy and paste special|Formats or have a macro do this for you
if you
want--just record a macro when you do it once manually and you'll have
your
code.

Les wrote:

Is there an easy way of not only transferring the contents of a cell to
another sheet within a workbook (which I do with an equation) but also
the
fill color of the cell. Right now I use an Indirect statement to get
this
done. I have 10 sheets (Sheet1 to Sheet10) which contain columns of
data
that may be different colors depending on the conditional statements. I
also have one summary sheet which will list all the data from the 10
sheets.
I prefer not to put the conditional statements into my summary page as
well
and is why I am hoping there is a way.

Thank you in advance,

Les

--

Dave Peterson

--

Dave Peterson