lost_my_SQL
New Member
- Joined
- May 3, 2019
- Messages
- 1
If I have a list of job titles [JBTBL], and a list of contract years [POPTBL]; I need to copy the list of job titles for as many times as I have years, lets call this the DetailTable. Then if I change/delete/add a job title from the job title table or add or delete a contract year from the POPTBL, i need the DetailTable to automatically reflect to these changes. This would save me hours of copy and pasting and re-working formulas.
**I refer to them as tables because they contain a lot more information but those are easy vlookups after i get the duplication figured out.
Hopefully my explanation makes sense.
<tbody>
</tbody>
<tbody>
</tbody>
Auto-Details Table
<tbody>
</tbody>
**I refer to them as tables because they contain a lot more information but those are easy vlookups after i get the duplication figured out.
Hopefully my explanation makes sense.
JBTBL |
PLUMBER |
CARPENTER |
<tbody>
</tbody>
POPTBL |
YEAR 1 |
YEAR 2 |
<tbody>
</tbody>
Auto-Details Table
POP | JOB |
YEAR 1 | PLUMBER |
YEAR 1 | CARPENTER |
YEAR 2 | PLUMBER |
YEAR 2 | CARPENTER |
<tbody>
</tbody>