Excel VBA Macro

Completed Posted 3 years ago Paid on delivery
Completed Paid on delivery

Looking for help in making a macro that will open a workbook as read only, specify the workbook by using a file path and then cycle through all the worksheets in that workbook and extract data based on a start and end date that is provided by the user. I need to extract the FAT data located in column 5 of certain worksheets in that workbook.

The extracted data will then be copied into a new workbook.

I have attached a sample file that I need to extra data from and run the macro on.

Excel Visual Basic Visual Basic for Apps Data Processing Software Architecture

Project ID: #25671645

About the project

19 proposals Remote project Active 3 years ago

Awarded to:

finecodervw

Hello Arsalan, I tried to look at the attachment but it is password protected, please share the password. Once I have a look at the file, we can discuss further on the requirement along with price and timeline. Looki More

$30 CAD in 2 days
(213 Reviews)
6.7

19 freelancers are bidding on average $81 for this job

TonmoyRoy111

Dear client I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I understand the requirements. I can definitely help. Kindly contact me for furt More

$100 CAD in 1 day
(438 Reviews)
7.2
AnowarRatul

$69 Only ----- Dear sir, I have read your project details and reviewed the attachment carefully. I can make the advance formula by maintaining 100% accuracy of your data absolutely as you want ------- Excel VBA Macro C More

$69 CAD in 2 days
(206 Reviews)
6.1
narsim3128

NOTE : I HAVE EXPERTISE IN VBA AND EXCEL. I CAN DELIVER THIS IN QUICK TIME With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. More

$140 CAD in 3 days
(66 Reviews)
6.0
mohamedrdait

Hello I can create the script using vba excel and make a dashboard to make it simple use please contact me for more details about the project best regards

$80 CAD in 2 days
(36 Reviews)
5.7
IgeS

Hi there, Need a macro that will extract data from all the sheets in a workbook based on the date criteria? Please message me if this is any of what you need. I’ll be standing by to help. -Reggie

$109 CAD in 2 days
(26 Reviews)
5.0
Mokshith30

hi i am vba developer experianced in vba macros & web scrapping i have read your requirements i can finish this job in a day only please share the details thanks

$50 CAD in 1 day
(51 Reviews)
5.0
merinsinha

Hi i am senior excel vba expert. As 10+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipati More

$50 CAD in 2 days
(51 Reviews)
4.6
webanis

Hello, I am an independent, experienced Excel VBA Sheet expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Anis D.

$40 CAD in 1 day
(24 Reviews)
4.2
yadavexpert53

Hello, 100% I can done before deadline. Please ping me for further details. If you may have questions pls. ask me. Thanks, Mohit

$100 CAD in 7 days
(24 Reviews)
4.0
Overseashelp

hello, i will be pleased to take care of your macro,. this will take 1 to 2 days of vba coding and i will ensure that it is working correctly. waiting to hear from you, thank you

$222 CAD in 2 days
(4 Reviews)
3.3
EDSRD

Hi, we have worked on several excel data and VBA projects. We can make a macro to open a file as read only and read all its sheets and get the desired data. We would be happy to help you with your work. Kindly contact More

$111 CAD in 2 days
(9 Reviews)
2.9
zhongguoswj

I have been working with excel for over 20 years, and working with VBA macros for over 10. I have really enjoyed using excel, and look forward to projects like this. Hoping I can help you with this project, looking to More

$56 CAD in 3 days
(2 Reviews)
2.6
omoboladeolumode

Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, R Programming Language More

$30 CAD in 1 day
(3 Reviews)
3.5
ojhawkins

Hi Arsalan, this will be straightforward and more than happy to help you get this done quickly. Feel free to reach out to myself and we can discuss what the workflow looks like and how you would like to use the propose More

$75 CAD in 1 day
(1 Review)
1.0
DavyDG

Hello I have read your description and i am interested in your project. I can complete your macros for you in no time with high levels of accuracy. I have completed a few projects similar to yours and I can show you my More

$100 CAD in 3 days
(1 Review)
0.0
arunchipa

Hi, i having 6 year of experience in excel based automation(workbook function, pivot, vba macro), Also having experience in Microsoft Access, oulook related automation and robotic process automation using UiPath. Did More

$30 CAD in 1 day
(1 Review)
0.0
ALEJANDRO2114

Buen Día Verificando su archivo y de acuerdo a mis habilidades puedo desarrollar lo que requiere de tal forma que sera fácil y agradable para el usuario final manteniendo la integridad de la información quedo atento More

$70 CAD in 7 days
(0 Reviews)
0.0
truelie1001

I'm an excel expert with plenty of dashboard and report automation experience along with the visualization skills. looking forward to work with you on this specific project.

$83 CAD in 2 days
(0 Reviews)
0.0