How to transfer specific data from one sheet to another?

**AI_DR_89** · 10-21-2021, 07:26 PM

Hi everyone!
I hope you're all doing great

Could you please help me with this?

I need something (formula, macros, whatever works best and it's easy to implement

) that helps me move from tab 1 (OPEN REQUESTS) to tab 2 (COMPLETED REQUESTS) the records that have a date under the Completed Date column, but I need these records to be automatically removed from the first tab once the date is placed, and moved into the "COMPLETED" tab. Is this possible?

Is it necessary/Should I add a column where it's marked as "Completed" or something?

**Pete_UK** · 10-21-2021, 07:33 PM

Welcome to the forum. A formula can't delete records after copying them across, so you would need a macro (VBA) for this. No need to start a new thread, though, as we all tend to read most threads, whichever sub-forum they are placed in.

I'm sure someone will come along soon, but they are bound to want more details from you about how your data is laid out, so please attach a sample Excel workbook by following the guidelines given in the yellow banner at the top of the screen.

Hope this helps.

Pete

**AI_DR_89** · 10-21-2021, 08:03 PM

Thank you, Pete!

I tried attaching the file to my original post, I think I pulled it off

Have a great day!

**JeteMc** · 10-26-2021, 05:43 PM

As Pete states a formula can not delete data, however it can copy the records and the original data could be filtered to show only records that have blank cells in the 'Completed On' field.
The formula using for copying the records is: =IFERROR(INDEX('OPEN REQUESTS'!A$2:A$13,AGGREGATE(15,6,(ROW('OPEN REQUESTS'!A$2:A$13)-ROW('OPEN REQUESTS'!A$1))/(ISNUMBER('OPEN REQUESTS'!$F$2:$F$13)),ROWS(A$2:A2))),"")
Note to see all records on the Open Requests sheet > select the filter in cell F1 and then select 'Clear Filter from Completed on'.
Let us know if you have any questions.

How to transfer specific data from one sheet to another?

LinkBack

Thread Tools

Rate This Thread

Display