Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto column insertion based on a number
I'm putting together a document to help personnel track training completion.
I have a cell where the user inputs the number of employee. I would like to be able to have excel automatically insert columns for employee training dates based on the number of employees entered. I want it to look something like this: Number of Employees: 4 Criteria Name 1 Name 2 Name3 Name 4 Training Requirement #1 Date Date Date Date Training Requirement #2 Date Date Date Date Training Requirement #3 Date Date Date Date Training Requirement #4 Date Date Date Date Individual Training % 100% 50% 100% 75% I've completed the template column (Name 1) with all of the required calculations, but don't know how to have the rest of the columns automatically added with the formulas. Any advice would be much appreciated. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
Auto row insertion based on a number | Excel Worksheet Functions | |||
Auto fill Column based on data in other columns | New Users to Excel | |||
Want a number of cells to be auto completed based on entry in one. | Excel Worksheet Functions | |||
Auto number w/ different letter-number combos in same column | Excel Worksheet Functions |