Eraengineer
Board Regular
- Joined
- Jun 12, 2011
- Messages
- 226
Hello All,
My first post! I am working on this scheduling project for work since everyone seems to enter parts into the system when ever they want. The employees use their own spread sheets wich complicates things more. With that said I'm sure I will have many questions on how to control all aspects of scheduling with visual basic locked Excel and Access databases. My goal is to start this in Excel and transition the work over to Access as I have done in many of my projects. The desired result is to know when a job should be at a machine and when it should be completed by planning and scheduling correctly.
Now for the question:
I'm looking for a vb code that will search a column and pull out the info out of the cells in the column and place it in a cell on a different worksheet. For example this is what I would have in a cell in D2 LZS,PBR,CHP,PRB. So, first the column D is identified, then the cells in the column are searched and if a cell contians LZS then LZS,PBR,CHP,PRB is copied and pasted in sheet LZS, sheet PRB, Sheet CHP, and sheet PRB.
The second issue I am having is that the 4 cells to the right of the column need to be selected as well and pasted in the appropriate sheets. This issue has bugged me for sometime. I look foward to the responses.
Is there a way I can post the excel sheet for download so everyone can see what has been layed out and what needs to be cleared up!? I have good code and forms in the project and as this project continues on I think it might serve as a good example for others looking to control sheduling issues.
My first post! I am working on this scheduling project for work since everyone seems to enter parts into the system when ever they want. The employees use their own spread sheets wich complicates things more. With that said I'm sure I will have many questions on how to control all aspects of scheduling with visual basic locked Excel and Access databases. My goal is to start this in Excel and transition the work over to Access as I have done in many of my projects. The desired result is to know when a job should be at a machine and when it should be completed by planning and scheduling correctly.
Now for the question:
I'm looking for a vb code that will search a column and pull out the info out of the cells in the column and place it in a cell on a different worksheet. For example this is what I would have in a cell in D2 LZS,PBR,CHP,PRB. So, first the column D is identified, then the cells in the column are searched and if a cell contians LZS then LZS,PBR,CHP,PRB is copied and pasted in sheet LZS, sheet PRB, Sheet CHP, and sheet PRB.
The second issue I am having is that the 4 cells to the right of the column need to be selected as well and pasted in the appropriate sheets. This issue has bugged me for sometime. I look foward to the responses.
Is there a way I can post the excel sheet for download so everyone can see what has been layed out and what needs to be cleared up!? I have good code and forms in the project and as this project continues on I think it might serve as a good example for others looking to control sheduling issues.