Moving row to another worksheet

[DJ_Rutts]

Hi,

I am hoping you can help. I have made a workbook which lists potential development or process ideas and fixes. I have made it so the rows auto colour based on department and also sort by priority, date (column D) and owner.

What I want to be able to do is move the row to the 'complete' or 'Not progressed' work sheet. It does not seem to be working properly with the code I have used.

It is copying over to the selected work sheet but not clearing it from the old work sheet.

My other issue is that the sorting and colour row is working on the 'ideas' and 'fixes' work sheets, but not on the 'completed' or 'not progressed' work sheets and I cannot see why. Is anyone able to help please?

I have attached a test version.

It is the 'proceed?' column that I used to choose either 'complete' or 'rejected' to move the row to another worksheet.

[arlu1201]

You do not need those functions to transfer the data which you have in the UDF module.

Just use this

Please Login or Register  to view this content.

to transfer the data from Ideas to Complete.

[DJ_Rutts]

Hi Arlette,

Thanks for the response.

I had help with the code on this workbook previously. Can you tell me where I should use the above code?

Also, the code in the UDF module states which column belongs where on the new sheet - how will this be maintained with the above code?

Cheers

Dan

[arlu1201]

The code i gave you had to go in the UDF itself. But i just checked that the first set of columns are continuous, but not the last 1 or 2. So you can actually split it up. Instead of having code like -

Please Login or Register  to view this content.

You can have it as
copy from A to J to A of the other sheet. (It will copy from A to J)
Then copy L or other individual columns. (just an example)

What i mean is you can group the continuous columns together.

If you explain a little more in detail, i can help you re-create the code.

[DJ_Rutts]

Sorry - I am still confused by this, because what you have put above is basically how the UDF is laid out at the moment?

Which part of the UDF actually needs to change?

Please Login or Register  to view this content.

[arlu1201]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[DJ_Rutts]

Sorry about that. Didn't know how to do that.

[DJ_Rutts]

Is anyone able to assist please...??

[arlu1201]

Maybe for now, we can let your original code be as is. Can you tell me which line is giving you the problem?

[DJ_Rutts]

If you refer back to my post which includes the code - I am unsure of what you are telling me to change, as this is how the UDF is laid out at the moment and it does not seem to be working?

[arlu1201]

Its not working entirely or is it giving you an error on a particular line?

Did you step through your code using the F8 key?