Find Jobs
Hire Freelancers

Excel VBA Debug: I need a From and To date/time filter on a pivot table.

$25-150 AUD

Completed
Posted over 2 years ago

$25-150 AUD

Paid on delivery
I have been trying to set up a filter in an excel spreadsheet so I can extract a start date and end date from my spreadsheet, then filter the results from a list of values based on the start and end dates. Whatever I try I end up with an error in my final step: [login to view URL]("ValPivot").PivotFields("DateTimeVal").[login to view URL] _ Type:=x1Between, _ Value1:=Start_DateTimeVal, _ Value2:=End_DateTimeVal I have tried using a variable as a Double, Long and Date format - it gives me different errors but still doesn't work. Attached is a sample of the type of data, the pivot tables and my sample code in an .xlsm workbook. I have two separate approaches - one pivot table using Date format and the other using Double. I only need one of them to work. Errors I get are Run Time 5; or Run Time 1004; or
Project ID: 32625114

About the project

19 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
$0 AUD in 1 day
5.0 (73 reviews)
5.3
5.3
19 freelancers are bidding on average $81 AUD for this job
User Avatar
Hi there, i have read your project and understood your requirement...I am an expert in excel and can do this project for you..will solve the error which you are facing..let's discuss in chat..thanks!!
$135 AUD in 1 day
5.0 (422 reviews)
6.7
6.7
User Avatar
"Sir, I am an Excel VBA MACRO Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. It is my Sixth month here and I have 115+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
$60 AUD in 1 day
4.9 (139 reviews)
6.3
6.3
User Avatar
"Hello Sir, I am an advance level EXCEL VBA EXPERT and all Excel related work. This is a basic work for me ,I will complete this task with 100 % Accuracy. I have completed similar projects with five stars from client. About me I am Chartered Accountant with more than 4 years of experience from worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expects 100% accuracy from me. I am Microsoft Excel, accounting, auditing, Form Creation in Excel through VBA and in Google Sheet and QuickBooks expert. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. Regards Spogmai Kakar "
$55 AUD in 1 day
5.0 (19 reviews)
3.8
3.8
User Avatar
WHY ME? I’ve read and understood your project description. I know the importance of on-line Business and assure prompt Response and excellent communication skills. I am known for my fast turnaround time and ability to fix difficult problems. Where others have failed, I will succeed. If I have bid on your project, just click that "Award" or "Chat" button.
$40 AUD in 1 day
5.0 (2 reviews)
2.5
2.5
User Avatar
Hello. Greetings for the day!!! As a Software Developer, I have 5+ years rich experiences working with C, C#, VB.NET and so on. I can complete your task perfectly. Give me a project and I'll discuss it in more detail and get started as soon as possible. Regard.
$100 AUD in 1 day
5.0 (1 review)
2.7
2.7
User Avatar
Hello sir, I have read your all instructions and I can do it efficiently. Give me this project and I will never disappoint you regarding your work and I will give you unlimited revision after completion of the work. Thanks.
$25 AUD in 1 day
5.0 (2 reviews)
1.3
1.3
User Avatar
Hello, Here to assist you in providing a SOLID and EXTENSIVE business plan for your business. Lets chat and discuss details. With 8 years of experience in writing professional business documents, plans and decks for organizations, entrepreneurial ventures and multi nation corporations. I am confident enough to create a strong business plan The 10 key components that are part of your business plan are: 1. Executive summary 2. Company description 3. Market analysis 4. Competitive analysis 5. Description of management and organization 6. Breakdown of your product and services 7. Marketing plan 8. Request for funding 9. Financial projections 10. Exit plan I have thorough knowledge about BUSINESS PLANS, FINANCIAL REPORTS, PRESENTATION SLIDES, CASE STUDIES, SALES MATERIALS, SOCIAL MEDIA UPDATES, WEBSITE COPYWRITING, BUSINESS BLOG WRITING, NEWSLETTER WRITING, WHITE PAPER CREATION and drafting an effective blueprint for them so that they could reach their desired target audience. I am confident I can exceed your expectations. BEST REGARDS
$88 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir, I am a professional of ms office works with 10 years experience. You have to glad to get my services.
$80 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am comfortable this project I am very faster Taiping MSWord and MS Excel please give me one chance
$95 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am the best person for this bid bcoz i can do this work before the time and i know all excel shortkey and good technical skills to layout and proper set margins .
$88 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a well trained in data entry work. I have worked over quality and accuracy of my work over years.
$135 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir, I can retype your data with good eyes on details. Assurance of quality output Kindly send me a message so that we can discuss further. Looking forward to working with you. Thanks and Regards
$88 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am capable of grasping new tools. I am a master of MS Office, Google Docs and spreadsheets. I am proficient in typing and can type up to 40 words a minute in English. I have both written and verbal communication skills. Accuracy and attention to details are my working characteristics. Microsoft access Excel, PowerPoint Microsoft Word Outlook Windows data entry Proofreading Transcriptions Telecommunication skills Web research projects Web scraping Organizational skills etc. If you want to hire me or know more about me, just send me a message on Skype or Email. I am always available and ready to work at any given time. You can surely assume that your job will be done perfectly on time. Feel free to have a conversation with me. I am waiting to hearing from you. Thank you.
$88 AUD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Balmoral, Australia
5.0
14
Payment method verified
Member since Oct 4, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.