Hey all, Sorry if this may be a very beginner task. I'm having a little difficultly. I'm a novice with Excel at best and working as IT support for a client who runs a Landscaping business.
I have a spreadsheet with Jobs. Date, Name, Crew, Done, Billed and Payed are the fields. I need to create a macro that filters undone jobs by crew on Sheet 2.
Sheet 2 will have only Undone Jobs and Organized by crew.
So I understand I filter by "text not containing 'X' " to see all the undone jobs. Then filter by "containing 'truck crew' to see all of truck crews undone jobs. Then copy and paste into Sheet 2.
Is there a better way to go about this for recording a macro to ensure my client will have a functioning macro when he needs to organize from a ever changing sheet1?
-Thanks a ton
I have a spreadsheet with Jobs. Date, Name, Crew, Done, Billed and Payed are the fields. I need to create a macro that filters undone jobs by crew on Sheet 2.
Sheet 2 will have only Undone Jobs and Organized by crew.
So I understand I filter by "text not containing 'X' " to see all the undone jobs. Then filter by "containing 'truck crew' to see all of truck crews undone jobs. Then copy and paste into Sheet 2.
Is there a better way to go about this for recording a macro to ensure my client will have a functioning macro when he needs to organize from a ever changing sheet1?
-Thanks a ton