+ Reply to Thread
Results 1 to 7 of 7

Data send one sheet to another sheet based on pressing the macro button

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Data send one sheet to another sheet based on pressing the macro button

    Dear All ,
    I am having some fruits list at column A of sheet “input”, and I need a macro that send fruits from sheet “input” to sheet “output” based on press the macro button. Explanation are below
    If I press the macro button 1st time, it will send 1st fruits name “Apple” (that contains at Column A of sheet “input” ) to the sheet “output” in the CELL B1.

    Again if press the macro button in 2nd time , it will send 2nd fruits name “Banana” (that contains at Column A of sheet “input” ) to the sheet “output” in the CELL B1.

    Again if press the macro button in 3rd time , it will send 3rd fruits name “Grapes ” (that contains at Column A of sheet “input” ) to the sheet “output” in the CELL B1.

    Again if press the macro button in 4th time , it will send 4th fruits name “Tomato ” (that contains at Column A of sheet “input” ) to the sheet “output” in the CELL B1.

    It will continue until blank CELL come at Column A of sheet “input” & a pop up message will be showing saying that “successful”
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Data send one sheet to another sheet based on pressing the macro button

    Since you are looking for each "fruit" only once, why not just use the filter function built into Excel.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: Data send one sheet to another sheet based on pressing the macro button

    Hi alansidman, thanks for interest regarding my issues , here I have total three macros to complete my whole activity the first one is done by me already , it is the 2nd macros , if it is done , then I will go for 3rd macros(that also done) . and finally I will cascade all three macros to get the actual results. If possible then help me for this macro.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Data send one sheet to another sheet based on pressing the macro button

    Hi nur,

    See if this code in the attached does what you need:
    Please Login or Register  to view this content.
    Public Row Number Counter.xlsm

    If you want to close the file and open it again and have it do the next fruit, you will need to save the row number in a cell somewhere before closing the file.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  5. #5
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: Data send one sheet to another sheet based on pressing the macro button

    Hi MarvinP , It works great but need to implement one more code so that if blank CELL come at Column A of sheet “input” & a pop up message will be showing saying that “successful” .

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Data send one sheet to another sheet based on pressing the macro button

    Change:
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: Data send one sheet to another sheet based on pressing the macro button

    Hi MarvinP , Yes ! it works perfectly , I really appreciated your nice job, Thanks for your valuable time in this regards.

+ 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. How can I pass information from one sheet to another by pressing a button?
    By daroman87 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-19-2017, 05:15 PM
  2. Replies: 0
    Last Post: 01-09-2017, 07:46 PM
  3. Replies: 1
    Last Post: 05-12-2016, 03:36 AM
  4. Replies: 2
    Last Post: 05-12-2016, 03:08 AM
  5. Replies: 1
    Last Post: 09-14-2014, 02:10 PM
  6. click button and send data from one sheet to another
    By Sonyk in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-18-2009, 06:10 PM
  7. Send Specific Data to New Spreadsheet by Pressing Button
    By mbrady1973 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2008, 10:28 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