Auto Populate Sheets by Employer
 

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! :D

Thank you for any assistance I can get!

Auto Populate Sheets by Employer
 

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! :D

Thank you for any assistance I can get!




--
rocked33