• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Date capture in Master sheet from User sheets

Hi All,

I need a help.!!
In the attached file, I need date should be come in master file from user sheets.
I want to sheet check user's start date and end date come in master sheet.

Please file the attached file for reference.

Thanks
 

Attachments

  • Test_Timesheet.xlsx
    23 KB · Views: 0
Hi deepak,

I really appreciate the you try, but desire result has not come yet.
Output is mentioned in col h & I.

Thanks

Hi,

Once you will update task details in col C you will get same result like as col H in Col F.

Or let me know if Col C would be like as 1,2,3,4....
 

Attachments

  • Test_Timesheet.xlsx
    22.6 KB · Views: 0
Hi,

Col c always be 1,2,3,4...
And Neelima, nitu Vikas.... all user's date should be come in master sheet.
like mention col H And Col I(Temporary Col).

Thanks
 
Heu Deepak,

Thanks it's working fine but i need your small help in Task/Activities column.
i want neelima's (for everyone) task come on neelima sheet but there is a prob in my formula. when i enter neelima below (highlighted in yellow color in attached sheet) repeat then task is not coming correctly. Please help to find out this. I want user task will come in front of user's sheet (user name can repeat below). Please find the attached file will give you more understanding.

Thanks for your help..!!
 

Attachments

  • Test_Timesheet.xlsx
    178.3 KB · Views: 0
Heu Deepak,

Thanks it's working fine but i need your small help in Task/Activities column.
i want neelima's (for everyone) task come on neelima sheet but there is a prob in my formula. when i enter neelima below (highlighted in yellow color in attached sheet) repeat then task is not coming correctly. Please help to find out this. I want user task will come in front of user's sheet (user name can repeat below). Please find the attached file will give you more understanding.

Thanks for your help..!!
Expected answers in F20 = ??
 
Hi,

I am not talking about date that is working perfect. Now, I want task (Col B) mention in master sheet should be come in neelima's sheet (col C). I did it but when i repeat the name in master sheet col C in Neelima's sheet is fetching wrong.
 
Hi deepak,

Still the prob is not solved, that why I posted the request in separately.
Boz formula for date is working but now facing problem to fetching task with user's name.

Please help me to solve the same.
 
Hi,

Would you pls be specific with desired result in a sample file so that we can address the concern issue.
 
Hi Deepak,

Please find the sample file.
In master sheet, I repeat name Mohit in row no. 19 and task for Mohit is Excel, So in Mohit's sheet task should be come "Excel" but it is fetching wrong(Visio)..same for others(Vishal & Vikas).
 

Attachments

  • Test_Timesheet.xlsx
    176.6 KB · Views: 0
Back
Top