Copying rows from table in sheet one doesn't go on table in sheet 2?

[MissCofnchtr]

Hello,

I'm creating an accuracy tracker for my workplace. I've managed to source a code from a lovely person here that allowed me to get the table on sheet one (Outstanding Checks) to automatically delete the row once column L (Check Completed?) was marked as yes. It moves the record to sheet two for me (Completed Checks) but it doesn't paste it to the first available row in the table on sheet two, it copies it to below the table.

Is there a way for it to automatically copy it from table in sheet one to table in sheet two rather than at the bottom of the table?

On top of this, my manager has request that I then create a seperate workbook that only he would have access to that collates only the records that have required rework. I have a column I (Rework Required?) so if this is marked as 'Yes' and column L (Check Completed?) is marked as 'Yes' then I would like it, if possible, that it copies the whole row to a third table in a completely different workbook that can still be autofiltered. The tables will be the same in all of the sheets / workbooks.

My table has the below headings:

Master Case / Client Surname / Client SCIN / SR Number / SR Sub Area / Pre or Post Check? / Date Sent for Pre Check / Comments / Rework Required? / Date Sent For Rework? / Caseworker / Check Complete?

Workbook One is called 'Accuracy Tracker', and Workbook Two is called 'Accuracy Rework'. I have used data validation in 'Rework Required?', 'Caseworker' and 'Check Complete?' if this makes a difference.

Can anyone help? I'm not terrible at Excel but this for some reason has be completed stumped!

Thanks in advance.

[vichopalacios]

Hi @MissCofnchtr

Before attempting to write any code line, we need some answers:

1.-
Before moving the row, do you need to check if the row is full filled,
meaning it may not contain empty cells?

2.-
If the answer for the first question is NO, then when do you want to execute de moving?
what would be the trigger?

[MissCofnchtr]

Hello,

Massive apologies for taking so long to reply, unfortunately I have been quite unwell. However! I am back at work now and have been asked to crack on with my tracker.

In answer to your questions:

1: I don't need to check the row is full filled

2: I would like to execute the moving once either one of two columns have been updated with 'Yes'.

I have three sheets: Outstanding Checks, Rework Required and Completed Checks

If Column L in Outstanding Checks is marked as 'Yes' then I need the row to be deleted and moved to 'Completed Checks'.

If Column M in Outstanding Checks is marked as 'Yes' then I need the row to be deleted and moved to 'Rework Required'.

On top of this, in 'Rework Required', if Column L is marked as 'Yes' then I need the row to be deleted and moved to 'Completed Checks'.

I have a table in 'Outstanding Checks' and would really prefer if a table could be added to the other two sheets too, so that all sheets can be filtered.

Any ideas?

Thanks in advance.

PS. I can attach the workbook if you need me to...

[vichopalacios]

Hi @MissCofnchtr
I hope you feel better now.

It can help a lot if you post a sample book, remember not to include sensitive data.
I'll be glad if I can help you.

Vicho

[MissCofnchtr]

Hi, here is the attachment! Thanks for your help.

[vichopalacios]

Hi @MissCofnchtr

Here you have a book, I think it solves the first part of your requirements.
please check it to see if it satisfy your needs.
Regarding the TABLE format, I've included an autofilter management, so don't really need that format

I need some more info about the new book for your boss...
.- you have to prepare the book, and he and only he is to work with it. ??
if so, this book has to retrieve info from "your" book
???

[MissCofnchtr]

Hi,

That book is PERFECT! thank you so much!

we decided not to go with the second book after all - he's just going to use the sheets in the book you've helped me with.

You've been amazing, thanks!!

[vichopalacios]

I'm glad it helped you.
Following the forum rules, If you found your inquire was satisfied, you should mark the thread as SOLVED.

A nice way to say thank you to anyone helped you, is clicking the Add Reputation star button at the lower left corner of the replay window.

Good luck, have a nice day.
Vicho