Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel spreadsheet
I'm having a problem making a macro perform the way I want.
Would anyone please help me solve my problem? I'll discribe my problem in detail if you respond. Thank you in advance. -- rbane |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel spreadsheet
Someone will respond. Please post details.
"rbane" wrote in message ... I'm having a problem making a macro perform the way I want. Would anyone please help me solve my problem? I'll discribe my problem in detail if you respond. Thank you in advance. -- rbane |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel spreadsheet
Here is my situation:
My spreadsheet has one row per day. I add an additional row every day. The values in each cell of the rows is the product of two other cells (call them 1A and 1B) that are located elsewhere on the spreadsheet. Each day I change the value of 1A and that causes the values in the cells in the rows to change accordingly. Each day before I change 1A however, I special paste all of the rows so that they do not change. I have set up a macro to do all that and that is working fine. However, I would like the macro to also automatically add another row for todays date so all I have to do is enter the value of 1A and the new row will reflect todays values. I hope that is clear and I really appreciate anyones help. -- rbane "PCLIVE" wrote: Someone will respond. Please post details. "rbane" wrote in message ... I'm having a problem making a macro perform the way I want. Would anyone please help me solve my problem? I'll discribe my problem in detail if you respond. Thank you in advance. -- rbane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Importing an Excel spreadsheet from the web. | Excel Discussion (Misc queries) | |||
Delay to startup excel spreadsheet | Excel Worksheet Functions | |||
copy and paste excel spreadsheet into autocad | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |