Macro code to identify a substring from a Word

[mvandhu]

Hi All,
I need help in a VBA code as I'm new to VBA macros in excel.

I have multiple rows (database objects) in 1st column

Ex. Input Sheet

Database Object Name:
EmployeeTable
EmployeeName
EmployeeAge
DepartmentView
DepartmentName
DepartmentEmployeeCount
DepartmentOwner


Requirement:
1. New worksheet to be created to have the output. The output sheet will have 2 columns as TableViewName, ColumnName.
2. If substring like 'Table' or 'View' are found in those rows, then outputsheet's TableViewName column to be populated with the cell value from Input worksheet.
3. If substring like 'Table' or 'View' are found in those rows then the outputsheet's ColumnName column to be populated with the cell value from Input worksheet.

Output Sheet


TableViewName ColumnName
EmployeeTable EmployeeName
EmployeeTable EmployeeAge
DepartmentView DepartmentName
DepartmentView DepartmentEmployeeCount
DepartmentView DepartmentOwner



Thank you in advance for helping me

[jindon]

Assuming the data in column A in Input Sheet

Please Login or Register  to view this content.