Excel Macro - selecting,copying and pasting

J - Sep 9, 2009 at 08:54 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Sep 13, 2009 at 06:38 AM

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

1 response