| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting values from a single dynamic cell to a list daily
I have a dynamic data sheet that is hooked up to a stock tradin monitor. The
sheet displays a portfolio which is ever changing. I want to take the portfolio value in a single cell and transfer to value in that cell on a daily basis to a list on another sheet. By doing this I will be able to track the fluctuations of my portfolio over time. How can this be done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting values from a single dynamic cell to a list daily
I don't think this is what you want, but this macro will copy the value in
A10 of the active sheet to the first empty cell in Column A of a sheet named "TheOtherSheet". Do you want a date also? HTH Otto "Terry" <Terry @discussions.microsoft.com wrote in message ... I have a dynamic data sheet that is hooked up to a stock tradin monitor. The sheet displays a portfolio which is ever changing. I want to take the portfolio value in a single cell and transfer to value in that cell on a daily basis to a list on another sheet. By doing this I will be able to track the fluctuations of my portfolio over time. How can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting unique values from a list using VBA | Excel Discussion (Misc queries) | |||
| Look up list of values based on single value from pick list | Excel Discussion (Misc queries) | |||
| Dynamic Range of Cell Values in a single Row | Excel Discussion (Misc queries) | |||
| create a list of single values from multiple values | Excel Worksheet Functions | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Linear Mode
