Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Populate from a Mater List into Sub Sheets | Excel Worksheet Functions | |||
Auto Populate from a Mater List into Sub Sheets | Excel Worksheet Functions | |||
Look up & auto populate between sheets | Excel Discussion (Misc queries) | |||
Auto holiday days populate on other sheets | Excel Worksheet Functions | |||
Can a macro - auto populate sheets... | Excel Discussion (Misc queries) |