| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to save a values of a cell in a new sheet as a new row
hi all, I need to copy the value of a cell in b9 and value of a cell in b19 from worksheet summary to a new work sheet historical data. These cells are subject to change frequently, so i need to keep the history data in teh new sheet. In the new sheet it should look something like this: Date Estimated effort 10-feb 23 11-feb 12 and so on. please help me by giving the excel code to achieve this.Its really urgent Thanks in advance.. -- dpt ------------------------------------------------------------------------ dpt's Profile: http://www.excelforum.com/member.php...o&userid=25861 View this thread: http://www.excelforum.com/showthread...hreadid=392446 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a Macro to "save as" filename from a cell on the sheet and then pr | Excel Discussion (Misc queries) | |||
| How can I save my sheet in macro | Excel Discussion (Misc queries) | |||
| Save only values of one sheet | Excel Discussion (Misc queries) | |||
| Macro to save as using two cell values inside worksheet | Excel Programming | |||
| Macro to insert values from a file and save another sheet as a .txt file | Excel Programming | |||
Threaded Mode
