To feed data from one cell of sheet1 to Data Table in sheet2

[Hansni]

Hi
I Have employee working hours data.
I want to Feed Coloumn C in Sheet2 from C5 in sheet1 only if Column B of Sheet2 matches with B2 of Sheet1.
Every time B2 of Sheet1 changes but I want to keep result in sheet2.
For example If Monika replaces Sara in sheet1 B2, Sara's working Hours will remain C2 of Sheet2 and put Monika working hour in C3 of Sheet2.

Any Help

I have attached file

[jraj1106]

Hi.

Check this out:

COMPAREANDCOPY.xlsm

[Hansni]

Thank you very much , It worked.

[Hansni]

Hi
I Have another scenario in which I have to do same thing but this time sheet 1 is a separate workbook.

I Have attached files. All files are in same folder .What I am trying to do is in master sheet first it open the file and If B2 of Individual staff matches list of column B in Master list then it copies Job no, start time and finish time of each day and paste against correct Name.

For example If I click command button it give me option to select file. I Selected Sara's File, it automatically put value of B9 saraworkbook to D7 of masterworkbook. C9 to E7 and so on.

your help will be really appreciated.

[jraj1106]

Hi.

Check this out:

Master sheet.xlsm

[Hansni]

Thanks once again you are a genius

[jraj1106]

You are welcome Hansni..

Please click the star below

[Hansni]

Hi Jraj

When I am trying to run Macro at work its says debug on below line. However it is working fine at my home Laptop with same file.I have changed name of workbook accordingly. I don't know why its not working. Any help

rcnt = Workbooks("TIMESHEETTEMPLATE").Sheets("Internal Copy").Range("S" & Rows.Count).End(xlUp).Row

[Hansni]

Hi Jraj
Now everything is working fine , that was something wrong with my user ID .

I Have another scenario. I have attached file. What I am trying to do is to convert time into 24 hours decimal hour. I have existing data which I want as in result data.

Any way to do this

Regards
Hansni

[jraj1106]

I'll check it and get back to you..

[Hansni]

Ok Thank you