hello, am working on a project and having difficulties to make it work. my aim is that to have buttons in ms excel, let's say that when i click on button1 it copy data from cell b19 and paste to cell p2, button1 copy data from cell c19 and paste to cell p2, etc... note cell p2 is a merge cells of p2 to r17. and when i complete my selection i can press another button that will send all these data to the next blank cell respectively eg: c19 goes to c20, etc
i need strong help from you, thank you
Copyright © 2024 Q2A.ES - All rights reserved.
Answers & Comments
Perhaps you can set to macro recording and paste the results in your question. Proficient users here should be able to clean up for you so you have a working macro that work flawlessly. Be aware that there is no undo for macros (as least for the version I am using) so you have to make a backup sheet in case any things go awry.