Insert data into a second sheet based on a condition

C

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.

  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 IdSiteRequestModeDateTimeOperatorRequestAssistanceRequestorEmployeeTypeLDAPBUDepartmentCompanyContactScopeRemarks
    N132-0000004
    		N132Mail7-Sep-202:09 AMVanjeetOpenOpening access area in
    absence of the owner    		Vishesh GuptaRegularvishegup@adobe.comCustomer ExperienceCustomer ExperienceAdobeRequest was completed by ISOCDrawer opened
    N132-0000005N132Mail7-Sep-202:12 AMAjayGSSQueryDSR Related QueryVinay ShahiVendorwal57161@adobe.comEmployee ExperienceGSSSecuritas35782Request was completed by ISOCQuery Resolved
    N132-0000006N132Mail
    		7-Sep-204:02 PMAmitOnsiteAssistanceexit formaltiesAstha KabraRegularastkabra@adobe.comCreative ProductAdobe DesignAdobeTransferred to ERC TeamNA
    N132-0000007N132Mail
    		8-Sep-2012:18 AMAjayOnsiteAssistanceIT Related QuerySucharita GhoshRegularsucghosh@adobe.comWWFOAdobe Customer SolutionsAdobeTransferred to Ops TeamPersonal belongings collection
    N132-0000008N132ExtensionCall8-Sep-201:23 AMAjayGSSQueryVendor relatedVinay ShahiVendorwal57161@adobe.comEmployee ExperienceGSSSecuritas35782Query was resolvedNA
    N132-0000009N132ExtensionCall8-Sep-201.29 AMAjayGSSQueryDSR Related QueryVinay ShahiVendorwal57161@adobe.comEmployee ExperienceGSSSecuritas35782Query was resolvedNA
    N132-0000010N132Mail8-Sep-208:58 AMSwatiOpenTech CaféSreejeshVendorcus60285@adobe.comEmployee ExperienceGSOC&WTransferred to Ops TeamTechcafe open
    N132-0000011N132Mail8-Sep-2010:10 AMVanjeetOnsiteAssistanceIT Related QueryMrinalini SardarRegularsardar@adobe.comCreative ProductAdobe DesignAdobeTransferred to Ops TeamPersonal belongings collection
    N132-0000012N132Mail8-Sep-2010:57 AMSwatiOpenShipment RoomSreejeshVendorcus60285@adobe.comEmployee ExperienceGSOC&WTransferred to Ops TeamShipment open
    N132-0000013N132Walky
    		8-Sep-2011:29 AMVanjeetGSSQueryIT Related QueryRaju PandeyVendorwal85634@adobe.comEmployee ExperienceGSSSecuritasWalkyQuery was resolvedNA
    N132-0000014N132Walky
    		8-Sep-2012:02 PMVanjeetGSSQueryMaterial EnquiryRaju PandeyVendorwal85634@adobe.comEmployee ExperienceGSSSecuritasWalkyQuery was resolvedNA
    N132-0000015N132Mail8-Sep-2012:35 PMVanjeetOnsiteAssistanceIT Related QueryAshish MishraRegularashishm@adobe.comCreative ProductCore Technologies & ProductsAdobeTransferred to Ops TeamPersonal belongings collection
The other sheet is as under:

Ops IdOps SiteReference IdSiteRequestMode
DateTimeOperatorRequestAssistanceRequestorEmployeeTypeLDAPBUDepartmentCompanyContactScopeRemarksRemarks
N25A-00001N25AN132-0000007N132Mail
8-Sep-2012:18 AMAjayOnsiteAssistanceIT Related QuerySucharita GhoshRegularsucghosh@adobe.comWWFOAdobe Customer SolutionsAdobe0Transferred to Ops TeamPersonal belongings collection
N132-00001N132N132-0000010N132Mail8-Sep-208:58 AMSwatiOpenTech CaféSreejeshVendorcus60285@adobe.comEmployee ExperienceGSOC&W0Transferred to Ops TeamTechcafe open
N132-00002N132N132-0000011N132Mail8-Sep-2010:10 AMVanjeetOnsiteAssistanceIT Related QueryMrinalini SardarRegularsardar@adobe.comCreative ProductAdobe DesignAdobe0Transferred to Ops TeamPersonal belongings collection
-00000N132-0000012N132Mail8-Sep-2010:57 AMSwatiOpenShipment RoomSreejeshVendorcus60285@adobe.comEmployee ExperienceGSOC&W0Transferred to Ops TeamShipment open
-00000N132-0000015N132Mail 8-Sep-2012:35 PMVanjeetOnsiteAssistanceIT Related QueryAshish MishraRegularashishm@adobe.comCreative ProductCore Technologies & ProductsAdobe0Transferred to Ops TeamPersonal belongings collection
Thanks,
Ciaz
 
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.
 
You must log in or register to reply here.
Back
Top