+ Reply to Thread
Results 1 to 9 of 9

Importing Data from one sheet to another using a button

  1. #1
    Registered User
    Join Date
    08-18-2015
    Location
    Dallas, TX
    MS-Off Ver
    2013
    Posts
    4

    Importing Data from one sheet to another using a button

    As the title says I'm trying to create a simple productivity tool for my work that will import the daily data input into another sheet to save for our records with the click of a button. Either using the "Record Daily Results" or "Import" buttons on the images attached I want to click those buttons and have them input the data into the correct cell for that day. However I am not so well informed on the creation of custom macros and cannot figure out how to get it to work for the life of me. There are two formats I came up with and a solution to either one would work. Thanks in advance!
    Attached Images Attached Images
    Last edited by XeroMaverick; 08-23-2015 at 08:53 AM.

  2. #2
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Importing Data from one sheet to another using a button

    Hiii please attach sample workbook with desired results
    Don`t care, take care...

    Regards,
    Mangesh

  3. #3
    Registered User
    Join Date
    08-18-2015
    Location
    Dallas, TX
    MS-Off Ver
    2013
    Posts
    4

    Re: Importing Data from one sheet to another using a button

    I hope this is what you meant.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Importing Data from one sheet to another using a button

    Hiii Sorry for late reply..
    Just one thing in your excel is to change date format to mm-dd-yyyy in Sheet "Daily Numbers"
    Also no need to put Import button to every date Just "Import at any cell" will do the work in attached file..
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-18-2015
    Location
    Dallas, TX
    MS-Off Ver
    2013
    Posts
    4

    Re: Importing Data from one sheet to another using a button

    Wow thank you so much. This is so much further then I ever would have gotten on my own. Only thing is I was testing it and the only date that properly imports the data is 08/18/2015. Every other date returns with #N/A as the result of transporting the data to "Daily Numbers".

  6. #6
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Importing Data from one sheet to another using a button

    Wait let me check

  7. #7
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Importing Data from one sheet to another using a button

    Hii now try this..
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    08-18-2015
    Location
    Dallas, TX
    MS-Off Ver
    2013
    Posts
    4

    Re: Importing Data from one sheet to another using a button

    Works perfectly and after checking out the macro....I never would've figured this out. Thank you SOOOOOO MUCH!

  9. #9
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Importing Data from one sheet to another using a button

    Ok then.. Please mark this thread as solved..... hit on Add Reputation to the answer if any one helps you in this forum...
    Last edited by mangesh.mehendale; 08-23-2015 at 03:20 AM.

+ 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. Importing data from one sheet to another
    By sawantarun in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2015, 11:56 AM
  2. importing data from one sheet to another
    By gman1907 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-25-2012, 01:51 AM
  3. Excel 2007 : Importing data from one sheet to another
    By MajorPayne in forum Excel General
    Replies: 1
    Last Post: 02-03-2011, 01:09 PM
  4. Having trouble importing a sheet of data from a closed workbook into a New Sheet.
    By Mr Cham in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-26-2010, 04:31 AM
  5. Importing DATA in tabular form fromone sheet to another sheet
    By rahulk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2010, 09:59 PM
  6. Importing data from one sheet to another
    By loleffe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2008, 02:58 AM
  7. importing data from other sheet
    By koldtooth in forum Excel General
    Replies: 3
    Last Post: 06-14-2006, 10:46 AM

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