Search the Text and Copy to File - VBA Code

[RShilkar]

Hi,

I have excel workbook (file A) where Column D has a list of items and Column C has defined the Sheet Tab Name.
From VBA I need to search each n every item (one by One) in another excel file (file B). if found then That need to copy again to file A on particular tab which is assigned in Column C in (File A).

Means the workflow will be like this -

Will take value from Column D from File A
Will search in another File B Workbook.
If found it will copy to Sheet in File A . sheet Name would be as assigned against that in Column C ( for e.g D3 has value 'ABC' then C3 has Sheet Name as 'Main'. So search text ABC from File B to copy File A under the Sheet Tab 'Main)

If not found - it will print 'Not found' in column E against that D column value.

Could you please help me on this with VBA code.

Thank you.

 

[RShilkar]

Hi,

I have excel workbook (file A) where Column D has a list of items and Column C has defined the Sheet Tab Name.
From VBA I need to search each n every item (one by One) in another excel file (file B). if found then That need to copy again to file A on particular tab which is assigned in Column C in (File A).

Means the workflow will be like this -

Will take value from Column D from File A
Will search in another File B Workbook.
If found it will copy to Sheet in File A . sheet Name would be as assigned against that in Column C ( for e.g D3 has value 'ABC' then C3 has Sheet Name as 'Main'. So search text ABC from File B to copy File A under the Sheet Tab 'Main)

If not found - it will print 'Not found' in column E against that D column value.

Could you please help me on this with VBA code.

Thank you.