software

Can someone help me with this problem?

Assume I have a row of cells named B1 and B2.
Today I want the value in B1 to be the product of A1 times A2.
Tomorrow, I will create another row of cells named C1 and C2. I will change
the value of A1 and I want the value in C1 to be the product of the new A1
times A2.
I do not want the old value in B1 to change from what it is today.
Can you help me with this?

Thank you very much,

Ron--
rbane

You could use a Change Event macro to trigger each time the value in A1 changes.

www.mvps.org/dmcritchie/excel/event.htm
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;rbanequot; gt; wrote in message ...
gt; Can someone help me with this problem?
gt;
gt; Assume I have a row of cells named B1 and B2.
gt; Today I want the value in B1 to be the product of A1 times A2.
gt; Tomorrow, I will create another row of cells named C1 and C2. I will change
gt; the value of A1 and I want the value in C1 to be the product of the new A1
gt; times A2.
gt; I do not want the old value in B1 to change from what it is today.
gt; Can you help me with this?
gt;
gt; Thank you very much,
gt;
gt; Ron
gt;
gt;
gt;
gt;
gt;
gt; --
gt; rbane
Unfortunately I am not that familar with macros. Could you tell me how to use
the macro you are referring to and help me through it?
Thank you very much.
--
rbanequot;David McRitchiequot; wrote:

gt; You could use a Change Event macro to trigger each time the value in A1 changes.
gt;
gt; www.mvps.org/dmcritchie/excel/event.htm
gt; --
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;rbanequot; gt; wrote in message ...
gt; gt; Can someone help me with this problem?
gt; gt;
gt; gt; Assume I have a row of cells named B1 and B2.
gt; gt; Today I want the value in B1 to be the product of A1 times A2.
gt; gt; Tomorrow, I will create another row of cells named C1 and C2. I will change
gt; gt; the value of A1 and I want the value in C1 to be the product of the new A1
gt; gt; times A2.
gt; gt; I do not want the old value in B1 to change from what it is today.
gt; gt; Can you help me with this?
gt; gt;
gt; gt; Thank you very much,
gt; gt;
gt; gt; Ron
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; --
gt; gt; rbane
gt;
gt;
gt;

In order to write a macro you need to know exactly what you want to happen,
and I don't think you have provided sufficient information to understand exactly
what you enter or want created automatically. For instance adding two rows at
a time not a typical spreadsheet application, so possibly you provided the
wrong cell addresses and meant for the additions to be on the same row, but
in any case I don't have an idea of the order that you are entering information
and what is to be automated.

In other words B1 and B2 are NOT on the same row.

When you change the value in A1 can the new row(s) be created
automatically, or id the calculated value going to appear when you
add a new cell(s) below.

If you look over the page reference I provided earlier you would get
an idea of what you can do and help you provide a better definition
of what you want done.

I designed a macro that works fine thanks to your suggestion.
Thanks again.
--
rbanequot;David McRitchiequot; wrote:

gt; In order to write a macro you need to know exactly what you want to happen,
gt; and I don't think you have provided sufficient information to understand exactly
gt; what you enter or want created automatically. For instance adding two rows at
gt; a time not a typical spreadsheet application, so possibly you provided the
gt; wrong cell addresses and meant for the additions to be on the same row, but
gt; in any case I don't have an idea of the order that you are entering information
gt; and what is to be automated.
gt;
gt; In other words B1 and B2 are NOT on the same row.
gt;
gt; When you change the value in A1 can the new row(s) be created
gt; automatically, or id the calculated value going to appear when you
gt; add a new cell(s) below.
gt;
gt; If you look over the page reference I provided earlier you would get
gt; an idea of what you can do and help you provide a better definition
gt; of what you want done.
gt; .
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;rbanequot; gt; wrote in message ...
gt; gt; Unfortunately I am not that familar with macros. Could you tell me how to use
gt; gt; the macro you are referring to and help me through it?
gt; gt; Thank you very much.
gt; gt; --
gt; gt; rbane
gt; gt;
gt; gt;
gt; gt; quot;David McRitchiequot; wrote:
gt; gt;
gt; gt; gt; You could use a Change Event macro to trigger each time the value in A1 changes.
gt; gt; gt;
gt; gt; gt; www.mvps.org/dmcritchie/excel/event.htm
gt; gt; gt; --
gt; gt; gt; ---
gt; gt; gt; HTH,
gt; gt; gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; gt; gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; gt; gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt; gt; gt;
gt; gt; gt; quot;rbanequot; gt; wrote in message ...
gt; gt; gt; gt; Can someone help me with this problem?
gt; gt; gt; gt;
gt; gt; gt; gt; Assume I have a row of cells named B1 and B2.
gt; gt; gt; gt; Today I want the value in B1 to be the product of A1 times A2.
gt; gt; gt; gt; Tomorrow, I will create another row of cells named C1 and C2. I will change
gt; gt; gt; gt; the value of A1 and I want the value in C1 to be the product of the new A1
gt; gt; gt; gt; times A2.
gt; gt; gt; gt; I do not want the old value in B1 to change from what it is today.
gt; gt; gt; gt; Can you help me with this?
gt; gt; gt; gt;
gt; gt; gt; gt; Thank you very much,
gt; gt; gt; gt;
gt; gt; gt; gt; Ron
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; rbane
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

HI rbane,
Thanks for telling me my webpage (event.htm) helped toward your own
solution.
---
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm

quot;rbanequot; gt; wrote...
gt; I designed a macro that works fine thanks to your suggestion.
gt; Thanks again.
My spreadsheet is not working exactly the way I want it to. The macro is
working, but not to the extent I want.
Would anyone care to help me work through my problem?
Thank you in advance.

--
rbanequot;David McRitchiequot; wrote:

gt; HI rbane,
gt; Thanks for telling me my webpage (event.htm) helped toward your own
gt; solution.
gt; ---
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt;
gt; quot;rbanequot; gt; wrote...
gt; gt; I designed a macro that works fine thanks to your suggestion.
gt; gt; Thanks again.
gt;
gt;
gt;

If you can break out the part that is not working then post it along
with at description; otherwise, email the macro and/or worksheet

Either way describe what is happening and what it is expected to do instead.
What data you are entering and when.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;rbanequot; gt; wrote in message ...
gt; My spreadsheet is not working exactly the way I want it to. The macro is
gt; working, but not to the extent I want.
gt; Would anyone care to help me work through my problem?
gt; Thank you in advance.
gt;
gt; --
gt; rbane
gt;
gt;
gt; quot;David McRitchiequot; wrote:
gt;
gt; gt; HI rbane,
gt; gt; Thanks for telling me my webpage (event.htm) helped toward your own
gt; gt; solution.
gt; gt; ---
gt; gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; gt;
gt; gt; quot;rbanequot; gt; wrote...
gt; gt; gt; I designed a macro that works fine thanks to your suggestion.
gt; gt; gt; Thanks again.
gt; gt;
gt; gt;
gt; gt;
Thank you so much for your offer, but someone else solved the problem for me
on another thread.
Thanks anyway for your offer.
--
rbanequot;David McRitchiequot; wrote:

gt; If you can break out the part that is not working then post it along
gt; with at description; otherwise, email the macro and/or worksheet
gt;
gt; Either way describe what is happening and what it is expected to do instead.
gt; What data you are entering and when.
gt;
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;rbanequot; gt; wrote in message ...
gt; gt; My spreadsheet is not working exactly the way I want it to. The macro is
gt; gt; working, but not to the extent I want.
gt; gt; Would anyone care to help me work through my problem?
gt; gt; Thank you in advance.
gt; gt;
gt; gt; --
gt; gt; rbane
gt; gt;
gt; gt;
gt; gt; quot;David McRitchiequot; wrote:
gt; gt;
gt; gt; gt; HI rbane,
gt; gt; gt; Thanks for telling me my webpage (event.htm) helped toward your own
gt; gt; gt; solution.
gt; gt; gt; ---
gt; gt; gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; gt; gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; gt; gt;
gt; gt; gt; quot;rbanequot; gt; wrote...
gt; gt; gt; gt; I designed a macro that works fine thanks to your suggestion.
gt; gt; gt; gt; Thanks again.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;