+ Reply to Thread
Results 1 to 2 of 2

Storing data on another sheet automatically by clicking button

  1. #1
    Registered User
    Join Date
    12-04-2020
    Location
    Tbilisi,Georgia
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    1

    Post Storing data on another sheet automatically by clicking button

    Hello everyone,

    I was just trying to create a button "Store results" which would automatically save the data on database sheet in one row. Attached is a picture of my sample data and I want to save those data that are in yellow on the other sheet in ONE ROW. I did it with the following code but at the same time I want that if data changes this new data to be added under the previous data on the database sheet. According to this code it's not added under the previous data it just overwrites it. Could you please help me how to solve this problem.

    Please Login or Register  to view this content.

    Thank you in advance.
    sample.PNG

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,763

    Re: Storing data on another sheet automatically by clicking button

    It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] pull out data from the table by clicking dropdown button
    By pejoi in forum Excel General
    Replies: 11
    Last Post: 02-09-2020, 11:19 AM
  2. Code to move data from one table to another by clicking a button
    By rlh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-02-2017, 02:18 PM
  3. Replies: 1
    Last Post: 06-01-2016, 04:02 AM
  4. Open a hidden sheet with clicking a button
    By Fixxxer1234 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-14-2014, 11:00 PM
  5. Replies: 1
    Last Post: 04-07-2013, 05:33 AM
  6. [SOLVED] Storing data results automatically in excel.
    By Maxtorathome in forum Excel General
    Replies: 5
    Last Post: 09-27-2012, 04:54 PM
  7. storing data on a particular sheet
    By herukuncahyono in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2010, 05:42 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1