I have a column 'A'(About 10 rows) with a drop down option in cell. I want copy the data and paste in another sheet and here i want ignore a cell contains "Please Select" in column A. Please help me with VBA code to resolve this issue. Thanks in advance
Welcome @Arun Kumar
Manual approach might me easiest. Use a filter, selecting the "Text Filters" option and then "Does not equal" and type "Please select" in the form. Now copy and paste to the new spreadsheet.
If you really need to do this with VBA, I suggest you record the above with the "record a macro" option op the developer ribbon. This will generate the required VBA code which you can modify as required.