+ Reply to Thread
Results 1 to 2 of 2

How to create a button that you can click to send data to a cell on another sheet?

  1. #1
    Registered User
    Join Date
    09-08-2012
    Location
    Indiana, US
    MS-Off Ver
    Excel 2010
    Posts
    1

    How to create a button that you can click to send data to a cell on another sheet?

    How can I create a button that you can click to send data from a range of cells to the next available cells in a specific column on another sheet?

    For example, the title of the button is Click to order and the click will transfer the text and numbers from Cell range D4-G4 from the sheet(Inventory) to the Order sheet's cell A2-D2.
    I am new to this field and would really appreciate if someone can help me with the following:
    1)How to Create a clickable Button.
    2)Create a macro to perform the function.
    3)How to post the macro.
    Thanks in advance.

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: How to create a button that you can click to send data to a cell on another sheet?

    Have you ever created a macro before??
    Gary's Student

+ 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