Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to automate this task
This task arises with historical stock prices - when a stock has had
splits. We have columns A,B,C,D and E. For each row in columns A,B,C and D, we want replace the old value in that row by New Value = Old value times (Value in column E /value in column D) This would effectively replace Column D by Column E and scale colums A B and C. How can this task be automated (I assume it would need a macro) ? Thansk for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to automate this task
Yes you need a macro if you want to fully automate it and replace the old data. however it seems that column E is used for the new info, so maybe you could just set a formula that checks if there is a value in column E, and if so, then use that data rather than the original data. ie =if(E1="",original calculation,revised calculation) Matt -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=561276 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to automate this task
Mallycat wrote: Yes you need a macro if you want to fully automate it and replace the old data. however it seems that column E is used for the new info, so maybe you could just set a formula that checks if there is a value in column E, and if so, then use that data rather than the original data. ie =if(E1="",original calculation,revised calculation) Matt yes; actually I thought of that - there is a "circular reference" problem - if in cell A1, I write "' = A1*E1/D1" excel doesn't like that. Is there a way to get around that ? Thanks. -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=561276 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
How do I get rid of task pane permanently? | Excel Discussion (Misc queries) | |||
change from copy & paste task pane (yuk) to c&p little box | Excel Discussion (Misc queries) | |||
can i automate task reminders in excel | Excel Discussion (Misc queries) | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) |