Trying to run multiple reports off of a button push that filters data by date and then copies the data depending on criteria.
So attached is "Book 1". It has 3 Sheets. A "Tasked" sheet that shows what work orders have been given to employees, a "Total Tickets" sheet that shows all work orders that have been received, and a "MACRO" page with date ranges for the 3 ways I'm trying to filter the data and buttons to use macros after dates are inputted.
I also attached "Book 2". It also has 3 sheets. "NOT TASKED", "TASKED AND NOT COMPLETE" and "TASKED AND COMPLETED". In Sheet 1 I am trying to pull data from "[login to view URL]) based off date but also comparing data between two sheets- Tasked([login to view URL]) and Total Tickets([login to view URL])- for duplicates in the TASK ID Column and only pulling rows that are not duplicates.
In Sheet 2 I am trying to pull data from [login to view URL] based off date but only copying rows that do not have any data in the "Completed Reference Number" Column.
In Sheet 3 I am trying to pull data from [login to view URL] based off date but only copying rows that only have data in the "Completed Reference Number" Column.
Lastly I would like to figure out a way to clear the sheets in "Book2" every time before the macro copies data over from "Book1".
I have Book2 Set up to what I want it to look like after the macro runs. Cheers
72 freelancers are bidding on average $135 for this job
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Willing to take up your project. Thank you, Regards.