rajesh2022
New Member
Hello All
I am working on excel workbook, where i will have 2 sheets. Sheet1 and Sheet2.
Sheet 2 will have my raw data, which contains employee names in column A and total hours they worked on Column D. and also user will input which week this data belongs to in I4 cell.
Now, i am trying to compare Employee from Sheet 2 with Employee in Sheet 1 (Column B). In Sheet 1, rows are fixed (From B3: B10), if match found, then i need to check date from Sheet2 I4 Cell and compare in Sheet 1 Row 2. and update hours under that employee.
I have attached sample file.
Can we achieve in vba?
I am working on excel workbook, where i will have 2 sheets. Sheet1 and Sheet2.
Sheet 2 will have my raw data, which contains employee names in column A and total hours they worked on Column D. and also user will input which week this data belongs to in I4 cell.
Now, i am trying to compare Employee from Sheet 2 with Employee in Sheet 1 (Column B). In Sheet 1, rows are fixed (From B3: B10), if match found, then i need to check date from Sheet2 I4 Cell and compare in Sheet 1 Row 2. and update hours under that employee.
I have attached sample file.
Can we achieve in vba?