Hey guys,
It has been a little while since I have posted so I hope you all are doing well! Anyways I have been given a project and I am looking for ideas getting started. I am not sure excel will be able to handle the project I have been given. Should I use Access? Or a program I am unaware of?! The following is what I must have this be able to do.
*must have a master list of the product with a list of part numbers and Parts.
<tbody>
</tbody>
(how its done now is the part numbers are copied and pasted onto a parts sheet and he hand writes part numbers on the list. The sheet printed is a 11x14 legal size page.)
*must be able to select a parts profile and insert on the list that will be printed.
<tbody>
</tbody>
(the sheet that they move to will basically be the same as the master list that will change depending on what is ordered and needs to be built)
*must be able to update master list when parts change
*once list is set be able to print the document for parts ordering.
Now that I type it out and list out the parameters I think it may be something Excel can do. But my question is will Access do it better? Or is there a better program that can do what I am asking better? Any insight would be great! I appreciate your time for reading and taking the timne to answer my questions!!
It has been a little while since I have posted so I hope you all are doing well! Anyways I have been given a project and I am looking for ideas getting started. I am not sure excel will be able to handle the project I have been given. Should I use Access? Or a program I am unaware of?! The following is what I must have this be able to do.
*must have a master list of the product with a list of part numbers and Parts.
Part number# | Part Name A | Part Name B | Part Name C | Part Name D |
Part# 123 | Part 1 | Part 2 | Part 3 | Part 4 |
Part# 456 | Part a | Part b | Part C | Part D |
<tbody>
</tbody>
(how its done now is the part numbers are copied and pasted onto a parts sheet and he hand writes part numbers on the list. The sheet printed is a 11x14 legal size page.)
*must be able to select a parts profile and insert on the list that will be printed.
Part number# | Part Name A | Part Name B | Part Name C | Part Name D |
Part# 123 | Part 1 | Part 2 | Part 3 | Part 4 |
Select this row | and move | to a page that | will change | daily. |
<tbody>
</tbody>
(the sheet that they move to will basically be the same as the master list that will change depending on what is ordered and needs to be built)
*must be able to update master list when parts change
*once list is set be able to print the document for parts ordering.
Now that I type it out and list out the parameters I think it may be something Excel can do. But my question is will Access do it better? Or is there a better program that can do what I am asking better? Any insight would be great! I appreciate your time for reading and taking the timne to answer my questions!!