+ Reply to Thread
Results 1 to 4 of 4

writing results of a refreshed table into a new line

  1. 04-03-2022, 09:43 AM #1
    Snokie_ffm is offline
    Registered User
    Join Date
    04-03-2022
    Location
    Germany
    MS-Off Ver
    Microsoft® Excel® für Microsoft 365 MSO (Version 2202 Build 16.0.14931.20128) 64 Bit
    Posts
    2

    Question writing results of a refreshed table into a new line

    Hi all,
    I would like to track the value of my stock portfolio over time.
    At the moment I just manually enter the value in a new line with the date in front so that I can later see a chart over time.
    Is there any way to automate this?
    For example that a new line with the current date is created when I push a function key or that this is automated and generated day by day?
    Thanks for your help with this in advance!
    Best,
    Snokie
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-03-2022, 09:45 AM #2
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,466

    Re: writing results of a refreshed table into a new line

    Welcome to the forum.

    You can't automate something like this without VBA. Is this an option? If so, I will move the thread to the right sub-forum.
    Last edited by AliGW; 04-03-2022 at 09:50 AM. Reason: Typo fixed.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 04-03-2022, 09:46 AM #3
    Snokie_ffm is offline
    Registered User
    Join Date
    04-03-2022
    Location
    Germany
    MS-Off Ver
    Microsoft® Excel® für Microsoft 365 MSO (Version 2202 Build 16.0.14931.20128) 64 Bit
    Posts
    2

    Re: writing results of a refreshed table into a new line

    Hi Ali, yes, would love to explore that option. Thank you !
    Reply With QuoteRegister To Reply
  4. 04-03-2022, 09:49 AM #4
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,466

    Re: writing results of a refreshed table into a new line

    Thread moved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combobox shows results from table, but returns run-time error when line selected
    By krugm0f0 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-19-2020, 04:07 PM
  2. Table - how to keep text against reference when refreshed
    By muss1210 in forum Excel General
    Replies: 2
    Last Post: 05-08-2018, 08:23 AM
  3. Help writing macro to reconcile two data sets and produce a results table
    By iMAQ_23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2018, 02:25 PM
  4. How to copy data from non-depending part of excel table to refreshed monthly table...
    By GulliverRi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-06-2014, 07:25 PM
  5. Pivot table formatting changes when refreshed
    By JasonBarnes in forum Excel General
    Replies: 0
    Last Post: 12-07-2010, 11:26 AM
  6. Keeping track of results of refreshed/updated data
    By vitaleca in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-02-2006, 10:50 PM
  7. Refreshed Pivot Table still have old items
    By suzetter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2005, 01:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1