coyotefest
New Member
- Joined
- Nov 5, 2014
- Messages
- 5
Hello All.
I am new to the form and will appreciate any help. A quick overview I have never coded in excel (macros, VBA) but have used MatLab and C so i do have a descent understanding of code.
The easiest way to explain it will be to add the table I'm working with
the first table is the master sheet
<tbody>
</tbody>
the next table is and example of one of the machines (each is a separate sheet but follows this format)
<tbody>
</tbody>
this table is what I would like to achive
<tbody>
</tbody>
The idea is that the user will type the information (failure date, description, work order) in the sheet assigned to a machine. the data will then be copied over to the new sheet. the machine # serial # model and date installed will not change but should still copy over as scene in the above example. Ideally if the user inputs data into machine 2 i should push the rows below machine 2 down. There are in total 8 machines but if 2 sheets(machines) working I can make the rest work.
I apologize for the lengthiness of the description but i think i have describe every thing.
again I have no background in VBA or macros but do understand code this is just out of my comfort zone.
Thank you all.
I am new to the form and will appreciate any help. A quick overview I have never coded in excel (macros, VBA) but have used MatLab and C so i do have a descent understanding of code.
The easiest way to explain it will be to add the table I'm working with
the first table is the master sheet
Machine # | Serial # | Model | Date installed | Failure date | description | work order |
1 | 123 | a | 5/15/14 | |||
2 | 456 | b | 5/15/14 | |||
3 | 789 | c | 5/15/14 |
<tbody>
</tbody>
the next table is and example of one of the machines (each is a separate sheet but follows this format)
Machine # | Serial # | Model | Date installed | Failure date | description | work order |
1 | 123 | a | 5/15/14 | 8/19/14 | hjddjhf | hfsh |
<tbody>
</tbody>
this table is what I would like to achive
Machine # | Serial # | Model | Date installed | Failure date | description | work order |
1 | 123 | a | 5/15/14 | 8/19/14 | hjddjhf | hfsh |
1 | 123 | a | 5/15/14 | 9/15/14 | hdhs | hjsk |
2 | 345 | b | 5/15/14 | |||
3 | 678 | c | 5/15/14 |
<tbody>
</tbody>
The idea is that the user will type the information (failure date, description, work order) in the sheet assigned to a machine. the data will then be copied over to the new sheet. the machine # serial # model and date installed will not change but should still copy over as scene in the above example. Ideally if the user inputs data into machine 2 i should push the rows below machine 2 down. There are in total 8 machines but if 2 sheets(machines) working I can make the rest work.
I apologize for the lengthiness of the description but i think i have describe every thing.
again I have no background in VBA or macros but do understand code this is just out of my comfort zone.
Thank you all.