Auto Populate Sheets by Employer

[rocked33]

Hey Guys!

I was wondering if I could get help with my dilemma.

I have a master sheet where I have all the jobs done by each of my
employees. Each employee also has their own sheet, so they can acces
the workbook, enter the information of their job (Job #, Due Date, Dat
Completed, Status, Notes) and I want to have the workbook auto-populat
the master list when employees populate their individual list. Th
master list has the same columns, except I want the master list to als
have a column with the employee's name who did the job. Is there a wa
to do this with functions or will I need VBA?

I've gone as far as I can with figuring things out. I made the statu
appear as "OVERDUE" when the date completed is later than the Due Dat
though!

Thank you for any assistance I can get

 

[Guest]

hi,

i think you will need vba for that
question how are you to update the master
is it included and hidden in the employee's workbook or is it totally
seperated
somehow you need to keep them synchronized


greetz

"rocked33" schreef in bericht

Hey Guys!

I was wondering if I could get help with my dilemma.

I have a master sheet where I have all the jobs done by each of my 5
employees. Each employee also has their own sheet, so they can access
the workbook, enter the information of their job (Job #, Due Date, Date
Completed, Status, Notes) and I want to have the workbook auto-populate
the master list when employees populate their individual list. The
master list has the same columns, except I want the master list to also
have a column with the employee's name who did the job. Is there a way
to do this with functions or will I need VBA?

I've gone as far as I can with figuring things out. I made the status
appear as "OVERDUE" when the date completed is later than the Due Date
though!

Thank you for any assistance I can get!