Completed

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

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

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: excel vba copy rows to another worksheet based on multiple criteria, excel copy data from one sheet to another if a condition is met, excel macro to copy rows from one sheet to another based on condition, excel macro to copy data from one sheet to another based on criteria, excel vba copy cells based on criteria, excel macro to copy data from one sheet to another based on date, copy data to another excel workbook based on criteria using vba, excel copy data from one sheet to another based on criteria, data excel workbook master workbook using vba, vba copy folders files date modifed, excel vba copy cell contents paste internet explorer, excel vba copy data explorer, vba copy cognos report excel, vba excel save format date, vba excel workbook update, excel vba copy data internet explorer, vba copy excel, excel vba copy single cell paste, vba open close excel workbook word macro, vba copy web report excel

About the Employer:
( 1 review ) Ankara, Turkey

Project ID: #17489563

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
(166 Reviews)
6.7

72 freelancers are bidding on average $135 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$200 USD in 2 days
(640 Reviews)
8.3
$250 USD in 2 days
(263 Reviews)
7.7
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
(295 Reviews)
7.7
$200 USD in 3 days
(223 Reviews)
7.3
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
(167 Reviews)
7.0
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
(217 Reviews)
6.8
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
(270 Reviews)
6.5
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
(115 Reviews)
6.5
MohsanEijaz

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

$111 USD in 3 days
(70 Reviews)
6.0
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
(102 Reviews)
6.2
SShtv

I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These are s More

$100 USD in 2 days
(61 Reviews)
5.7
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
(77 Reviews)
5.8
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
(62 Reviews)
5.5
usmanhassan123

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

$250 USD in 1 day
(40 Reviews)
5.8
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
(35 Reviews)
5.6
abhinovpankaj

Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat More

$155 USD in 3 days
(66 Reviews)
5.6
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
orugantn

Hi, I am good with Excel and VBA. I reviewed the files and I will be able to complete the work this week. Can you please contact to discuss more on the project. Please feel free to contact. Thank you! Regar More

$200 USD in 3 days
(28 Reviews)
5.2
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
(76 Reviews)
5.3
$45 USD in 2 days
(53 Reviews)
5.1