Macros to Copy Certain Rows from One Workbook to Another Workbook

**rajeshapril14** · 05-14-2012, 12:55 PM

Hi, I have similar issue, But I want needs to copy if it contains "Approved" "Rejected" "Hold".

But below is accepting only "Approved" how to add other 2. If copy non-blanks also ok for me.

Please Login or Register  to view this content.

**Kelshaer** · 05-14-2012, 01:06 PM

Try this:

Please Login or Register  to view this content.

**rajeshapril14** · 05-14-2012, 02:08 PM

Thanks Kalshaer. Its working great. I am breaking my heads for last 6 hours. I am not good on Excel.

**rajeshapril14** · 09-16-2012, 06:22 AM

Hi Kalshaer, Hope you are doing good.

Need your help once again. In the below once selection done in column "U", it will date and time automatically in column "T" and copy the list of info to another workbook. Until that no problem for me.

I need to add lock option. Once any choice is selected in "U"and copied I want the cell needs to be lock to avoid further selection in single cell. Based on below, it is not happening. Pls help.

Please Login or Register  to view this content.

**Cutter** · 09-16-2012, 07:40 AM

@ rajeshapril14

Welcome to the forum.

Please notice that code tags have been added to your posts. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.