+ Reply to Thread
Results 1 to 4 of 4

How to transfer specific data from one sheet to another?

  1. #1
    Registered User
    Join Date
    10-21-2021
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    2

    Lightbulb How to transfer specific data from one sheet to another?

    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?
    Attached Files Attached Files
    Last edited by AI_DR_89; 10-21-2021 at 08:00 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,928

    Re: How to transfer specific data from one sheet to another?

    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

  3. #3
    Registered User
    Join Date
    10-21-2021
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    2

    Re: How to transfer specific data from one sheet to another?

    Thank you, Pete!

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

    Have a great day!

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    12,882

    Re: How to transfer specific data from one sheet to another?

    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.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to transfer specific data from one sheet to another?
    By jreloz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2021, 08:57 PM
  2. How to transfer specific data from one sheet to another?
    By jreloz in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-22-2021, 12:12 AM
  3. Transfer Specific Cell Data from one sheet to dump sheet
    By markusvirus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-11-2019, 08:56 AM
  4. Require VBA code to Transfer specific data from one sheet to another sheet.
    By xlhelp7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2017, 10:20 AM
  5. Replies: 5
    Last Post: 02-09-2014, 08:29 PM
  6. [SOLVED] Transfer specific data onto new sheet
    By Johfra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2013, 11:33 AM
  7. [SOLVED] Beginner Here: I need Macros to transfer specific data from one sheet to another sheet
    By aleem5 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-08-2013, 12:36 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1