Macro to copy row information from sheet to sheet won't work

**beth.randall** · 09-05-2012, 04:29 PM

I have a workbook with two worksheets. I am trying to run a macro that will copy row information from sheet "jobs" to sheet "open jobs" when column G has a Y entered in the cell.

This is the code I am using:

Please Login or Register  to view this content.

but when I run the macro it does not move any information

I also want a pop up that will tell me that the information is complete but I do not know how to do that.

I am sure the error is probably user issues but I do not know how to fix it from here.

Thanks,

Beth

**rollis13** · 09-05-2012, 05:06 PM

Works fine. Did you copy the macro in the "Jobs" sheets' code module ? Are you using the right letter case (Y/y) ?

**Winon** · 09-05-2012, 05:25 PM

Try,

Please Login or Register  to view this content.

If you want the Code to ignore Upper- or Lower Case, we can incorporate that for you.

Hope that helps.

Also see the "Please consider" Note at the bottom of this post.

**beth.randall** · 09-07-2012, 12:12 PM

JOBS 1.xlsmHere is my spreadsheet. I do have it copied in the "Jobs" sheet module. I didn't know case sensitivity was a problem. But now, after changing the code to the one suggested on this thread, I can not even view it as a macro to try to run it. I do not know what went wrong but the code is there and I believe in the right place.

**rollis13** · 09-07-2012, 04:55 PM

Go back to your script post #1 and just change "y" to "Y" and it will copy your row only when you write Y in a cell of column G:

Please Login or Register  to view this content.

But I have the feeling that you aren't after this. If I understand (better) you don't want the copying done at once when you write the Y, but you want it to run through all the rows now that the Y and N are already in place. Am I right ?

**VBA FTW** · 09-07-2012, 06:08 PM

Try changing:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

Also change the y to Y

Not sure why it isn't working though. I removed the ByVal Target As Range and was able to step into it 1 time, but only once. That issue is a little beyond me

**Winon** · 09-08-2012, 06:12 AM

Try the attached WorkBook.

The Code is not in a Module. It is in the Worksheet_Change_Event of Sheet2.

Hope that helps.

Also see the "Please consider" Note at the bottom of this post.

**beth.randall** · 09-10-2012, 10:26 AM

That works beautifully.....thank you!!

**Winon** · 09-10-2012, 12:49 PM

You are welcome.

Glad I could help.

**Winon** · 09-10-2012, 01:31 PM

Sorry, I completely forgot about your request for:

I also want a pop up that will tell me that the information is complete but I do not know how to do that.

Does the attached WorkBook comply with that need?

Also see the "Please consider" Note at the bottom of this post. Click on the star at the bottom left of the post to add to my reputation.