Adjust a row copy macros

[dreddster]

Hey Guys,

I have this macro added to the code on the worksheet that does the following:
Basically if on column 21 you type Yes, the whole row is copied on sheet "Extract" on the first available row.

Please Login or Register  to view this content.

However on Sheet "Extract" it turned out I need to have additional columns. How do I modify the macro to copy the row only up to column 20 (including column 20)?

Thank you!

[Excelnoub]

Do you need to clear Column 21 once the transfer is complete?

Do you also need to clear the row or just act like a copy and paste on the next available row?

[Excelnoub]

Please Login or Register  to view this content.

Let me know if this works for you

[Excelnoub]

If you need the info to stay in you previous sheet (not the Sheets("Extract")) Then delete

Please Login or Register  to view this content.

[dreddster]

Hey Excelnoub,

The column is AA. I replaced my macro with yours and updated it like this:

Please Login or Register  to view this content.

But it doesn't seem to copy anything when I write Yes in AA. Did i update it correctly ?

[Excelnoub]

Do you press Enter? I would add a Validation list in your Column AA so the when you drop down and select Yes the code will run.

Try clicking in the cell again the code will run...

Add Application.CutCopyMode = False after the last End If

[Excelnoub]

Give me one min I have the same kind of code in one of my workbook and works like a charm...

I will rearange the code to fit what you need.

[dreddster]

Thank you Excelnoub.

[Excelnoub]

Please Login or Register  to view this content.

[dreddster]

This one indeed works like a charm!

Thank you once again for your help!

[Excelnoub]

But keep in mind that this will not clear the content in Cell, row 27 ("AA"), So you will need to add this if you need to clear the cell AA from the "Yes"

Please Login or Register  to view this content.

[Excelnoub]

Also...

For Screenupdating:

Please Login or Register  to view this content.

Sorry for the multiple post I am doing 5 things at once lol

[dreddster]

On the extract sheet I removed the Yes column entirely. Screenupdating addition is nice!
Haha yes, I know the feeling. I am also jumping between 3 workbooks, depending on the priority

Only thing left is the sorting of names by divisions in different sheets in the other topic. When you have a chance I will appreciate if you can help me out on that macro for me.