VBA: find value of a cell in a named range tab from other sheet, then write something in the next column of the same row

[captainflo22]

Hello,
I have a file who's the first sheet act as a Main menu, where I make some tab's, Named all to be able to move something and avoid error.

I have an employee tab, containing multiple column, and some vba code to select the employee name then a checkbox to make a new sheet with all employee data's., based on a hidden template sheet.
everythings work well.
For now I want to make a button on each employee sheet who report on the main sheet if completion is done.

Here i'm stuck, because i want it to be dynamic based on the value of the employee cell, look in the main tab, then write on the 7th column of the tab

I tried with Vlookup, but i can't get the address of the cell to edit

could you help me?

thanks

 

[captainflo22]

Hello,
I have a file who's the first sheet act as a Main menu, where I make some tab's, Named all to be able to move something and avoid error.

I have an employee tab, containing multiple column, and some vba code to select the employee name then a checkbox to make a new sheet with all employee data's., based on a hidden template sheet.
everythings work well.
For now I want to make a button on each employee sheet who report on the main sheet if completion is done.

Here i'm stuck, because i want it to be dynamic based on the value of the employee cell, look in the main tab, then write on the 7th column of the tab

I tried with Vlookup, but i can't get the address of the cell to edit

could you help me?

thanks