Hi,
I have a workbook which contains a list of machinery on one sheet.
Then there is a corresponding worksheet for each machine number to enter defects for that machine on.
I also have a worksheet called "SUMMARY" which lists each machine that has defects awating repair.
I want to develope some code that will take the machine number and description from the top row of that machines defects sheet,
search the "SUMMARY" worksheet for the description.
If that machine is already in the summary sheet, I want to find the next available row and enter the defects.
If that machine is not already in the "SUMMARY" worksheet i want it to go to the bottom of the document and add the machine and defects to the "SUMMARY" sheet.
Can this be done? any help or advice would be mcuh appreciated.....
NOTE: I already have a useform working that adds the defects and a few other things to the corresponding worksheet which is determined from a combobox with a list of the machine numbers.
I have a workbook which contains a list of machinery on one sheet.
Then there is a corresponding worksheet for each machine number to enter defects for that machine on.
I also have a worksheet called "SUMMARY" which lists each machine that has defects awating repair.
I want to develope some code that will take the machine number and description from the top row of that machines defects sheet,
search the "SUMMARY" worksheet for the description.
If that machine is already in the summary sheet, I want to find the next available row and enter the defects.
If that machine is not already in the "SUMMARY" worksheet i want it to go to the bottom of the document and add the machine and defects to the "SUMMARY" sheet.
Can this be done? any help or advice would be mcuh appreciated.....
NOTE: I already have a useform working that adds the defects and a few other things to the corresponding worksheet which is determined from a combobox with a list of the machine numbers.
