I was asked to create several macros for an in-house project since I have some (very limited) programming skills. I have done pretty well except for two things. I have a set of field logs that come in and need to have reports created. My problems are as follows:
1. I need to be able to take data entered through a user form (i.e. a leak value that might be a single number or a range) and filter the field log by that info. In other words, a tech will enter a value into the user form. The field log must then be filtered by that value and certain information placed in a new sheet. I can create the user form. I need help with the code to use that input to filter the field log and copy certain columns into a new sheet.
2. I have created a user form that allows the tech to insert his/her name, ID, etc. I have also created a header with the same titles. How do I get the input from the user form to show up in the header? (i.e. I have a header code that says "Technician Name:" "Technician ID:" etc. but need the actual input to enter in after the title.)
Thanks a bunch to anyone who can help.
1. I need to be able to take data entered through a user form (i.e. a leak value that might be a single number or a range) and filter the field log by that info. In other words, a tech will enter a value into the user form. The field log must then be filtered by that value and certain information placed in a new sheet. I can create the user form. I need help with the code to use that input to filter the field log and copy certain columns into a new sheet.
2. I have created a user form that allows the tech to insert his/her name, ID, etc. I have also created a header with the same titles. How do I get the input from the user form to show up in the header? (i.e. I have a header code that says "Technician Name:" "Technician ID:" etc. but need the actual input to enter in after the title.)
Thanks a bunch to anyone who can help.