Results 1 to 2 of 2

Thread: Insert data into a second sheet based on a condition

  1. #1
    Neophyte Ciaz's Avatar
    Join Date
    Aug 2015
    Posts
    2
    Articles
    0
    Excel Version
    Office 365

    Insert data into a second sheet based on a condition



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I have two sheets in which I enter data. In both the sheets based on certain condition I want the data to be inserted and sorted date and time wise.

    1. The sheets have reference ids (Auto populated).
    2. "Control" sheet in Column R has the condition "Transfer to Ops Team".
    3. If this condition is met then the whole row is copied to the "Phy Sec" sheet at the appropriate time and place.
    4. The Phy Sec team would also be entering data in this sheet manually.
    5. I am looking for the enteries to be sorted as per the date and time.
    6. Similarly if "Transferred to Control" is enetred in the "Phy Sec" sheet then the row is copied to the Control sheet and sorted as per the date and time.

    7. Reference Id Site RequestMode Date Time Operator Request Assistance Requestor EmployeeType LDAP BU Department Company Contact Scope Remarks
      N132-0000004 N132 Mail 7-Sep-20 2:09 AM Vanjeet Open Opening access area in
      absence of the owner
      Vishesh Gupta Regular vishegup@adobe.com Customer Experience Customer Experience Adobe Request was completed by ISOC Drawer opened
      N132-0000005 N132 Mail 7-Sep-20 2:12 AM Ajay GSSQuery DSR Related Query Vinay Shahi Vendor wal57161@adobe.com Employee Experience GSS Securitas 35782 Request was completed by ISOC Query Resolved
      N132-0000006 N132 Mail 7-Sep-20 4:02 PM Amit OnsiteAssistance exit formalties Astha Kabra Regular astkabra@adobe.com Creative Product Adobe Design Adobe Transferred to ERC Team NA
      N132-0000007 N132 Mail 8-Sep-20 12:18 AM Ajay OnsiteAssistance IT Related Query Sucharita Ghosh Regular sucghosh@adobe.com WWFO Adobe Customer Solutions Adobe Transferred to Ops Team Personal belongings collection
      N132-0000008 N132 ExtensionCall 8-Sep-20 1:23 AM Ajay GSSQuery Vendor related Vinay Shahi Vendor wal57161@adobe.com Employee Experience GSS Securitas 35782 Query was resolved NA
      N132-0000009 N132 ExtensionCall 8-Sep-20 1.29 AM Ajay GSSQuery DSR Related Query Vinay Shahi Vendor wal57161@adobe.com Employee Experience GSS Securitas 35782 Query was resolved NA
      N132-0000010 N132 Mail 8-Sep-20 8:58 AM Swati Open Tech Café Sreejesh Vendor cus60285@adobe.com Employee Experience GSO C&W Transferred to Ops Team Techcafe open
      N132-0000011 N132 Mail 8-Sep-20 10:10 AM Vanjeet OnsiteAssistance IT Related Query Mrinalini Sardar Regular sardar@adobe.com Creative Product Adobe Design Adobe Transferred to Ops Team Personal belongings collection
      N132-0000012 N132 Mail 8-Sep-20 10:57 AM Swati Open Shipment Room Sreejesh Vendor cus60285@adobe.com Employee Experience GSO C&W Transferred to Ops Team Shipment open
      N132-0000013 N132 Walky 8-Sep-20 11:29 AM Vanjeet GSSQuery IT Related Query Raju Pandey Vendor wal85634@adobe.com Employee Experience GSS Securitas Walky Query was resolved NA
      N132-0000014 N132 Walky 8-Sep-20 12:02 PM Vanjeet GSSQuery Material Enquiry Raju Pandey Vendor wal85634@adobe.com Employee Experience GSS Securitas Walky Query was resolved NA
      N132-0000015 N132 Mail 8-Sep-20 12:35 PM Vanjeet OnsiteAssistance IT Related Query Ashish Mishra Regular ashishm@adobe.com Creative Product Core Technologies & Products Adobe Transferred to Ops Team Personal belongings collection

    The other sheet is as under:

    Ops Id Ops Site Reference Id Site RequestMode Date Time Operator Request Assistance Requestor EmployeeType LDAP BU Department Company Contact Scope Remarks Remarks
    N25A-00001 N25A N132-0000007 N132 Mail 8-Sep-20 12:18 AM Ajay OnsiteAssistance IT Related Query Sucharita Ghosh Regular sucghosh@adobe.com WWFO Adobe Customer Solutions Adobe 0 Transferred to Ops Team Personal belongings collection
    N132-00001 N132 N132-0000010 N132 Mail 8-Sep-20 8:58 AM Swati Open Tech Café Sreejesh Vendor cus60285@adobe.com Employee Experience GSO C&W 0 Transferred to Ops Team Techcafe open
    N132-00002 N132 N132-0000011 N132 Mail 8-Sep-20 10:10 AM Vanjeet OnsiteAssistance IT Related Query Mrinalini Sardar Regular sardar@adobe.com Creative Product Adobe Design Adobe 0 Transferred to Ops Team Personal belongings collection
    -00000 N132-0000012 N132 Mail 8-Sep-20 10:57 AM Swati Open Shipment Room Sreejesh Vendor cus60285@adobe.com Employee Experience GSO C&W 0 Transferred to Ops Team Shipment open
    -00000 N132-0000015 N132 Mail 8-Sep-20 12:35 PM Vanjeet OnsiteAssistance IT Related Query Ashish Mishra Regular ashishm@adobe.com Creative Product Core Technologies & Products Adobe 0 Transferred to Ops Team Personal belongings collection
    Thanks,
    Ciaz

  2. #2
    Neophyte octagon's Avatar
    Join Date
    Sep 2020
    Location
    TX
    Posts
    1
    Articles
    0
    Excel Version
    2010
    Doesn't it already fill the similar values automatically? If I understood correctly, you want the similar values entered automatically when you input one? I am using a similar table right now at work and, for example, when I enter property in Greece to a cell the other values automatically entered.

Posting Permissions

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