Excel Interface/ Master excel for repository

%3CLINGO-SUB%20id%3D%22lingo-sub-2411092%22%20slang%3D%22en-US%22%3EExcel%20Interface%2F%20Master%20excel%20for%20repository%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2411092%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20%3CSTRONG%3Ethree%3C%2FSTRONG%3E%20excel%20files%20as%20shown%20below%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22602px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22131.2px%22%3E%3CSTRONG%3EDepartment%20A%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22131.2px%22%3E%3CSTRONG%3EID%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2284px%22%3E%3CSTRONG%3EPart%20No%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2280px%22%3E%3CSTRONG%3ESer.%20No%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2297.6px%22%3E%3CSTRONG%3EDescription%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2288px%22%3E%3CSTRONG%3EIssue%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22120px%22%3E%3CSTRONG%3ESolution%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22131.2px%22%3E2153%3C%2FTD%3E%3CTD%20width%3D%2284px%22%3E10154865%3C%2FTD%3E%3CTD%20width%3D%2280px%22%3EASD251%3C%2FTD%3E%3CTD%20width%3D%2297.6px%22%3EScrew%3C%2FTD%3E%3CTD%20width%3D%2288px%22%3EDimension%3C%2FTD%3E%3CTD%20width%3D%22120px%22%3EScrap%2F%20Rework%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22131.2px%22%3E%3CFONT%20color%3D%22%230000FF%22%3E2148%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%2284px%22%3E%3CFONT%20color%3D%22%230000FF%22%3E10158693%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%2280px%22%3E%3CFONT%20color%3D%22%230000FF%22%3EAWS248%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%2297.6px%22%3E%3CFONT%20color%3D%22%230000FF%22%3EFlange%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%2288px%22%3E%3CFONT%20color%3D%22%230000FF%22%3EWear%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22120px%22%3E%3CFONT%20color%3D%22%230000FF%22%3EBlast%20%26amp%3B%20Paint%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22595px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22120px%22%3E%3CSTRONG%3EDepartment%20B%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22120px%22%3E%3CSTRONG%3EID%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2280px%22%3E%3CSTRONG%3EPart%20No%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2270.4px%22%3E%3CSTRONG%3ESer.%20No%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2297.6px%22%3E%3CSTRONG%3EDescription%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22115.2px%22%3E%3CSTRONG%3EIssue%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22110.4px%22%3E%3CSTRONG%3ESolution%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22120px%22%3E2218%3C%2FTD%3E%3CTD%20width%3D%2280px%22%3E10154865%3C%2FTD%3E%3CTD%20width%3D%2270.4px%22%3EAWS271%3C%2FTD%3E%3CTD%20width%3D%2297.6px%22%3ESling%3C%2FTD%3E%3CTD%20width%3D%22115.2px%22%3ECertification%3C%2FTD%3E%3CTD%20width%3D%22110.4px%22%3Erecertify%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22120px%22%3E%3CFONT%20color%3D%22%230000FF%22%3E2148%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%2280px%22%3E%3CFONT%20color%3D%22%230000FF%22%3E10158693%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%2270.4px%22%3E%3CFONT%20color%3D%22%230000FF%22%3EAWS248%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%2297.6px%22%3E%3CFONT%20color%3D%22%230000FF%22%3EFlange%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22115.2px%22%3E%3CFONT%20color%3D%22%230000FF%22%3EPaint%20peel%20off%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22110.4px%22%3E%3CFONT%20color%3D%22%230000FF%22%3EPaint%20touchup%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22599px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22123.2px%22%3E%3CSTRONG%3EDepartment%20C%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123.2px%22%3E%3CSTRONG%3EID%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2284px%22%3E%3CSTRONG%3EPart%20No%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2284px%22%3E%3CSTRONG%3ESer.%20No%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3E%3CSTRONG%3EDescription%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22113.6px%22%3E%3CSTRONG%3EIssue%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2288.8px%22%3E%3CSTRONG%3ESolution%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123.2px%22%3E%3CFONT%20color%3D%22%230000FF%22%3E2148%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%2284px%22%3E%3CFONT%20color%3D%22%230000FF%22%3E10158693%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%2284px%22%3E%3CFONT%20color%3D%22%230000FF%22%3EAWS248%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3E%3CFONT%20color%3D%22%230000FF%22%3EFlange%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%22113.6px%22%3E%3CFONT%20color%3D%22%230000FF%22%3ESurface%20finish%3C%2FFONT%3E%3C%2FTD%3E%3CTD%20width%3D%2288.8px%22%3E%3CFONT%20color%3D%22%230000FF%22%3ERework%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22123.2px%22%3E2218%3C%2FTD%3E%3CTD%20width%3D%2284px%22%3E10154865%3C%2FTD%3E%3CTD%20width%3D%2284px%22%3EAWS271%3C%2FTD%3E%3CTD%20width%3D%22104px%22%3ESling%3C%2FTD%3E%3CTD%20width%3D%22113.6px%22%3ECertification%3C%2FTD%3E%3CTD%20width%3D%2288.8px%22%3Erecertify%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20I%20need%20to%20merge%20these%20tables%20and%20create%20new%20excel%20sheet%20to%20be%20used%20as%20a%20repository.%20Say%2C%20the%20master%20excel%20sheet%20should%20have%20provision%20for%20search%20bar%20to%20search%20for%20the%20column%20header.%20For%20eg.%2C%20if%20I%20search%20for%20flange%2C%20it%20should%20automatically%20pull%20the%20three%20rows%20of%20data%20from%20Dep%20A%2C%20B%20and%20C%20to%20be%20displayed%20in%20my%20master%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20do%20it%3F%20or%20I%20need%20to%20create%20an%20interface%20for%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2411092%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello Everyone!!

 

I have three excel files as shown below,

 

Department A
IDPart NoSer. NoDescriptionIssueSolution
215310154865ASD251ScrewDimensionScrap/ Rework
214810158693AWS248FlangeWearBlast & Paint

 

Department B
IDPart NoSer. NoDescriptionIssueSolution
221810154865AWS271SlingCertificationrecertify
214810158693AWS248FlangePaint peel offPaint touchup

 

Department C
IDPart NoSer. NoDescriptionIssueSolution
214810158693AWS248FlangeSurface finishRework
221810154865AWS271SlingCertificationrecertify

 

Now, I need to merge these tables and create new excel sheet to be used as a repository. Say, the master excel sheet should have provision for search bar to search for the column header. For eg., if I search for flange, it should automatically pull the three rows of data from Dep A, B and C to be displayed in my master sheet.

 

Is there a way to do it? or I need to create an interface for this

 

Thanks

1 Reply

@Vignesh2112 

To be sure, that shall work on Excel for web?