+ Reply to Thread
Results 1 to 6 of 6

Storing data results automatically in excel.

  1. #1
    Registered User
    Join Date
    09-23-2012
    Location
    Midlands UK
    MS-Off Ver
    Excel 2016
    Posts
    13

    Post Storing data results automatically in excel.

    I do not know if this can be done in excel, without VB

    I am an average user of excel but by no means an expert in formula

    I have a number of cells that change value when i press F9 to refresh

    What i want excel to do each time i press F9 is to grab the results and store them in sequence in another worksheet line by line.


    The manual way is to

    Press f9, Copy the data in the cells switch to the Results worksheet sheet Paste Results,

    Go back press f9 (New Results) copy results reopen results worksheet and paste resuts below the last results.

    And so on


    I want excel to create the results in the "Results whorsheet" for me (The data on the Results Worksheet would grow every time i press F9 )

    Thanks for any Advice

    Regards
    Richard


  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,772

    Re: Storing data results automatically in excel.

    i assume that when you paste the 1st set of values, you are using paste values, and not just paste?

    if you upload a sample, we can create a macro (VBA) that will do what you want
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    09-23-2012
    Location
    Midlands UK
    MS-Off Ver
    Excel 2016
    Posts
    13

    Thumbs up Example Sheet Storing data results automatically in excel.

    Thanks for such a fast response

    I have uploaded a sample sheet for you,

    Worksheet 1 creates the data whenF9 is pressed and worksheet 2 is where i paste the results manually

    What i want excel to do is add this data automatically each time i press F9 to create the results in the format shown

    Thanks for your time and fast response

    Regards


    Example Requirement for Auto Data Storage.xlsx

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,772

    Re: Storing data results automatically in excel.

    see if the attached gives you what you need? click the macro button, it will do the recalc, and transpose the data to sheet2

  5. #5
    Registered User
    Join Date
    09-23-2012
    Location
    Midlands UK
    MS-Off Ver
    Excel 2016
    Posts
    13

    Re: Storing data results automatically in excel.

    Thanks for your support this works fine and solved my request

    Best Regards

    Richard

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,772

    Re: Storing data results automatically in excel.

    you'r welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1