Extracting values from a single dynamic cell to a list daily

T

Terry

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?
 
O

Otto Moehrbach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use data from external sources 4
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
VBA - exporting serial letters to single documents 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Applying a formula to multiple values within a single cell? 1
Extracting values from formulas 3
Pasting a range to a single cell 0
Lookup Multiple Values in Dynamic Ranges 0

Top