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”
Bookmarks