Excel Macro - selecting,copying and pasting Closed

Question

Hello,

I am trying to find a code which will enable me to select, copy and paste specific cells.

I have a macro which will place an "X" in a cell after the user inputs this ultimately highlights the info the user wants. And I want to program the macro so that it can copy and paste any cells which are populated with "x" to another worksheet so it is consolidated. Because the "X" are dynamic i need a code which can do that

Any help greatly appreciated

sharpman · Answer

Have a read of the following links, they refer to what you are requesting.

http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/
https://forums.techguy.org/threads/excel-copy-paste-macro-for-selected-cells.622241/
https://stackoverflow.com/questions/84331/is-there-a-macro-to-conditionally-copy-rows-to-another-worksheet
https://www.automateexcel.com/vba/cut-copy-paste-with-macro/
https://ccm.net/forum/affich-76418-excel-macro-for-copy-paste-selected-range

hope it helps.

Excel Macro - selecting,copying and pasting

1 response

Similar discussions

Subscribe To Our Newsletter!