If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel spreadsheet setup
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 |
#2
|
|||
|
|||
Excel spreadsheet setup
You could use a Change Event macro to trigger each time the value in A1 changes.
http://www.mvps.org/dmcritchie/excel/event.htm -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "rbane" wrote in message ... 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 |
#3
|
|||
|
|||
Excel spreadsheet setup
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. -- rbane "David McRitchie" wrote: You could use a Change Event macro to trigger each time the value in A1 changes. http://www.mvps.org/dmcritchie/excel/event.htm -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "rbane" wrote in message ... 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 |
#4
|
|||
|
|||
Excel spreadsheet setup
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. |
#5
|
|||
|
|||
Excel spreadsheet setup
I designed a macro that works fine thanks to your suggestion.
Thanks again. -- rbane "David McRitchie" wrote: 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. . --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "rbane" wrote in message ... 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. -- rbane "David McRitchie" wrote: You could use a Change Event macro to trigger each time the value in A1 changes. http://www.mvps.org/dmcritchie/excel/event.htm -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "rbane" wrote in message ... 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 |
#6
|
|||
|
|||
Excel spreadsheet setup
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: http://www.mvps.org/dmcritchie/excel/excel.htm "rbane" wrote... I designed a macro that works fine thanks to your suggestion. Thanks again. |
#7
|
|||
|
|||
Excel spreadsheet setup
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. -- rbane "David McRitchie" wrote: 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: http://www.mvps.org/dmcritchie/excel/excel.htm "rbane" wrote... I designed a macro that works fine thanks to your suggestion. Thanks again. |
#8
|
|||
|
|||
Excel spreadsheet setup
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: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "rbane" wrote in message ... 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. -- rbane "David McRitchie" wrote: 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: http://www.mvps.org/dmcritchie/excel/excel.htm "rbane" wrote... I designed a macro that works fine thanks to your suggestion. Thanks again. |
#9
|
|||
|
|||
Excel spreadsheet setup
Thank you so much for your offer, but someone else solved the problem for me
on another thread. Thanks anyway for your offer. -- rbane "David McRitchie" wrote: 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: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "rbane" wrote in message ... 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. -- rbane "David McRitchie" wrote: 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: http://www.mvps.org/dmcritchie/excel/excel.htm "rbane" wrote... I designed a macro that works fine thanks to your suggestion. Thanks again. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Error importing Excel spreadsheet into an existing Access table. | StargateFanFromWork | New Users | 6 | December 15th, 2005 06:16 PM |
Excel Range Value issue (Excel 97 Vs Excel 2003) | Keeno | General Discussion | 2 | June 13th, 2005 02:01 PM |
Importing Excel Spreadsheet Problem | Steve Goodrich | New Users | 7 | February 24th, 2005 01:35 PM |
Changing Text in Both An Excel Spreadsheet and a Spreadsheet's Cha | Alan Sexter | Worksheet Functions | 2 | August 13th, 2004 09:06 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |