Ciaz
New member
- Joined
- Aug 10, 2015
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
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.
Thanks,
Ciaz
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.
- The sheets have reference ids (Auto populated).
- "Control" sheet in Column R has the condition "Transfer to Ops Team".
- If this condition is met then the whole row is copied to the "Phy Sec" sheet at the appropriate time and place.
- The Phy Sec team would also be entering data in this sheet manually.
- I am looking for the enteries to be sorted as per the date and time.
- 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.
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 ownerVishesh 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
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 | 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 | 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 | 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 | 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 |
Ciaz