Multiple VBA Copy data functions from one excel workbook to another based on date and data criteria on macro button push
$30-250 USD
Pagado a la entrega
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
Nº del proyecto: #17489563
Sobre el proyecto
Adjudicado a:
Greetings! I can develop a macro to generate Book2 as a report in the format that you require for the user specified dates. Being a full time freelancer working exclusively on Excel based projects, I work on develop Más
64 freelancers están ofertando un promedio de $133 por este trabajo
Hello, I can help with you in your project Multiple VBA Copy data functions from one excel workbook to another based on date and data criteria on macro button push I have more than 5 years of experience in Data Más
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
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
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.
I can do it fro you quickly and exactly . Please contact me for saving your time and your money .
Hi: I have reviewed your projects details and understand that you have a workbook where you have two sheets, "Tasked" and "Total Tickets" , with data. You want a macro which would allow you filter data based on data r Más
I have a lot of expertise on this kind on job, I just starting on freelancer thats why my fee is low, but my work is great
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Más
I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (AP Más
Sir, I am very able to create this macro to suffice your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from you. with thanks and Más
Complete Automation. I have more than 10 years of experience in Excel and VBA with 100% client satisfaction history. See my profile for client reviews.
Hello, I went thru the description I have done similar projects as like this Kindly contact me, I will do this project for you You may see my previous projects and reviews I look forward to hearing from you Tha Más
I am VBA expert,please send me details.................................................................................
Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv Más
I will help you with your project. I have more than 20 years of experience in VBA Excel macro programming. Satisfaction guaranteed.
Hi, I just completed a VBA project for another employer. Please check my reviews. I know my stuff. I am not low balling you at this price. It will take me 4 hrs to make the Macro's, test and deliver to you. If you Más