software

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

--

Dave Peterson

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

quot;Dave Petersonquot; gt; wrote in message
...
gt; Formulas return values to the cells with the formula. They don't return
gt; formatting.
gt;
gt; You could copy and paste special|Formats or have a macro do this for you
if you
gt; want--just record a macro when you do it once manually and you'll have
your
gt; code.
gt;
gt; Les wrote:
gt; gt;
gt; gt; Is there an easy way of not only transferring the contents of a cell to
gt; gt; another sheet within a workbook (which I do with an equation) but also
the
gt; gt; fill color of the cell. Right now I use an Indirect statement to get
this
gt; gt; done. I have 10 sheets (Sheet1 to Sheet10) which contain columns of
data
gt; gt; that may be different colors depending on the conditional statements. I
gt; gt; also have one summary sheet which will list all the data from the 10
sheets.
gt; gt; I prefer not to put the conditional statements into my summary page as
well
gt; gt; and is why I am hoping there is a way.
gt; gt;
gt; gt; Thank you in advance,
gt; gt;
gt; gt; Les
gt;
gt; --
gt;
gt; Dave Peterson
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:
www.cpearson.com/excel/events.htm

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

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

Les wrote:
gt;
gt; Hi Dave,
gt;
gt; Yes I understand what you say that formulas return values. I do not want to
gt; consider a macro since I want this to be an automatic method. If that is
gt; the only way to do it then I have no choice but to use conditional
gt; formatting on my summary sheet just like I use on the other 10 sheets.
gt;
gt; Thank you very much for trying to help Dave I appreciate it,
gt;
gt; Les
gt;
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt; gt; Formulas return values to the cells with the formula. They don't return
gt; gt; formatting.
gt; gt;
gt; gt; You could copy and paste special|Formats or have a macro do this for you
gt; if you
gt; gt; want--just record a macro when you do it once manually and you'll have
gt; your
gt; gt; code.
gt; gt;
gt; gt; Les wrote:
gt; gt; gt;
gt; gt; gt; Is there an easy way of not only transferring the contents of a cell to
gt; gt; gt; another sheet within a workbook (which I do with an equation) but also
gt; the
gt; gt; gt; fill color of the cell. Right now I use an Indirect statement to get
gt; this
gt; gt; gt; done. I have 10 sheets (Sheet1 to Sheet10) which contain columns of
gt; data
gt; gt; gt; that may be different colors depending on the conditional statements. I
gt; gt; gt; also have one summary sheet which will list all the data from the 10
gt; sheets.
gt; gt; gt; I prefer not to put the conditional statements into my summary page as
gt; well
gt; gt; gt; and is why I am hoping there is a way.
gt; gt; gt;
gt; gt; gt; Thank you in advance,
gt; gt; gt;
gt; gt; gt; Les
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson

--

Dave Peterson