Multiple VBA Copy data functions from one excel workbook to another based on date and data criteria on macro button push

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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

Data Entry Data Processing Excel Visual Basic Visual Basic for Apps

Project ID: #17489563

About the project

64 proposals Remote project Active 5 years ago

Awarded to:

ksriniravi

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 More

$90 USD in 3 days
(261 Reviews)
7.2

64 freelancers are bidding on average $133 for this job

schoudhary1553

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 More

$250 USD in 3 days
(597 Reviews)
8.5
TonmoyRoy111

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

$150 USD in 3 days
(516 Reviews)
7.8
elqueabandona

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

$150 USD in 4 days
(344 Reviews)
7.5
periyannas

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.

$155 USD in 3 days
(190 Reviews)
7.0
zebracaro

I can do it fro you quickly and exactly . Please contact me for saving your time and your money .

$150 USD in 3 days
(136 Reviews)
7.2
aarifakhtar

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 More

$111 USD in 3 days
(182 Reviews)
7.1
MohsanEijaz

I am excel and vba expert, I can run your report and copy data. Mohsan

$111 USD in 3 days
(100 Reviews)
6.9
urielbaray

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

$30 USD in 2 days
(62 Reviews)
6.5
usmanhassan123

PhD in computer science having seven years of experience in Excel development.

$250 USD in 1 day
(93 Reviews)
6.5
vsprybhanu

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 More

$120 USD in 3 days
(153 Reviews)
6.2
archanaoswal

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 More

$150 USD in 2 days
(96 Reviews)
6.1
sonarkaushik

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 More

$155 USD in 3 days
(104 Reviews)
6.2
osmemon

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.

$66 USD in 3 days
(34 Reviews)
5.6
nelumindralal

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 More

$155 USD in 3 days
(41 Reviews)
5.3
Diliphero

Greetings, I am professionally qualified Business & Financial Consultant from Sri Lanka with a degree in Management & Finance. I am proficient in VBA, Macros, and Excel Dashboards. I have the experience in supporti More

$75 USD in 3 days
(18 Reviews)
5.0
nvbishr

I am VBA expert,please send me details.................................................................................

$70 USD in 2 days
(10 Reviews)
4.9
prabakarm23

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 More

$166 USD in 3 days
(59 Reviews)
4.9
wiisetech

Hi, I can do this job for you. I have done it many times and I am professional in it. Will give you the work as per your requirements and according to your satisfaction. Deliver it on time and with quality work. Wai More

$222 USD in 4 days
(43 Reviews)
4.3
rickygzz85

I will help you with your project. I have more than 20 years of experience in VBA Excel macro programming. Satisfaction guaranteed.

$50 USD in 2 days
(13 Reviews)
3.4
monachowdary81

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 More

$66 USD in 1 day
(3 Reviews)
2.0