| have a list of employees (by ID number) and date (by | | | | repeating). |
| yr & mon) of when they were assigned a certain duty | | | | 2. Show Jan data in col B, Feb data in col C, etc., and |
| (task). This is in a Work book, on a TAB. Each TAB is | | | | some columns will be blank because the ID had no |
| a separate month (first is Jan, 2nd is Feb, etc.). I have | | | | assignment that month, and will not be on the |
| 12 tabs (12 worksheets) in workbook. Each TAB, a | | | | worksheet for that month. |
| single month, has a list of ID numbers. Some IDs may | | | | Is there a formula, or function, or does it have to be |
| repeat on different worksheets, that is, some may be | | | | done in VBasic? (Is it even possible?) |
| in multiple months and some may be in just two or | | | | I have the workbook with 12 tabs in it, and now have |
| three months or just one month. An ID number will | | | | to manually put the ID columns side by side and copy |
| shown only once in a month for a single task (duty). | | | | and slide down one side on the other to get them to |
| Abbreviated example is below.multiple criteria in a | | | | match, and repeat the process 12 times to get the |
| INDEX/MATCH Formula | | | | yearly data on one worksheet. |
| Thehave a list of employees (by ID number) and date | | | | Is it possible to combine the data, by function, or |
| (by yr & mon) of when they were assigned a certain | | | | formula, or VBasic) to a 13th worksheet automatically |
| duty (task). This is in a Work book, on a TAB. Each | | | | and: |
| TAB is a separate month (first is Jan, 2nd is Feb, etc.). I | | | | 1. Show a list of all ID numbers in order (without |
| have 12 tabs (12 worksheets) in workbook. Each TAB, | | | | repeating). |
| a single month, has a list of ID numbers. Some IDs may | | | | 2. Show Jan data in col B, Feb data in col C, etc., and |
| repeat on different worksheets, that is, some may be | | | | some columns will be blank because the ID had no |
| in multiple months and some may be in just two or | | | | assignment that month, and will not be on the |
| three months or just one month. An ID number will | | | | worksheet for that month. |
| shown only once in a month for a single task (duty). | | | | Is there a formula, or function, or does it have to be |
| Abbreviated example is below.multiple criteria in a | | | | done in VBasic? (Is it even possible?) |
| INDEX/MATCH Formula | | | | I have the workbook with 12 tabs in it, and now have |
| The | | | | to manually put the ID columns side by side and copy |
| Is it possible to combine the data, by function, or | | | | and slide down one side on the other to get them to |
| formula, or VBasic) to a 13th worksheet automatically | | | | match, and repeat the process 12 times to get the |
| and: | | | | yearly data on one worksheet. |
| 1. Show a list of all ID numbers in order (without | | | | |