Insert column and then populate date when matching

Hi All,

I have two sheet available in below path
Master.xls='C:\temp'
Company_list=''C:\child'

I want to insert one column name as"Sector" and then populate company name when the User_fullname (col U) is matching with Name column from another sheet "Company_list".
Once it is over, the master sheet will be automatically saved and then all sheet will be closed.

Could you please help me.

Try

Please Login or Register  to view this content.

Thank yoiu Jindon for your great help.

Master workbook sheet name is always changing. is it possible to change the macro by mentioning "sheet1" in stead of "Data".
I tried but I am getting run time error 9.

With Sheets("sheet1").Cells(1).CurrentRegion

error 9 means sheet1 is not correct.
It might have extra space(s).

How about

Please Login or Register  to view this content.

?

Thank you once again. Its working fine. Thank you kev for help

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thank You Jindon for your guidance.

When I run the macro, it is working fine. whenever there is no matching in the data, it displays values as zero.
As the column is text field, is it possible to display blank in stead of zero for mismatch user name

?
If the cell format is General as your sample workbook, it should be no value when no match.
I can not replicate your problem.

Do you want to upload that workbook?

You need to edit your last post and wrap the code with the code tags.
[noparse][code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

It is a strict forum rule.

BTW
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]
should be
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]