Excel VBA automated looped macro

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

I would like to have a macro loop written in VBA that does two things...

1) Updates filters on 8 different sheets every hour

2) Saves the workbook file every night at midnight with the file name [login to view URL] and then clears the data to start over again.

I already have this workbook set-up and working properly, it gathers data from an arduino board and utilizes PLX-DAQ to populate the data into my workbook every 10-15 seconds... but I am stuck trying to get this functionality working within my project. For a person that's experienced in VBA, this shouldn't be a hard task... Also, it doesn't need to be a macro, if you know of a better way to accomplish what I'm trying to accomplish, then I'll go with that... I'll provide more details when I find the right freelancer for the job...

Data Processing Excel VB.NET Visual Basic Visual Basic for Apps

Project ID: #16489195

About the project

8 proposals Remote project Active 6 years ago

Awarded to:

vlayausa

Hello, I have a lot of experience with Excel and VBA, I made a lot of various macros. I would love to help you with this one. It sounds quite interesting and not too complicated, I am sure I could finish it in v More

$111 USD in 1 day
(140 Reviews)
5.8

8 freelancers are bidding on average $123 for this job

Gangsong

Hello I have read your job description and I can support you perfectly. I have rich experience in excel and vba scripts. Hope to discuss more. Thanks

$155 USD in 3 days
(5 Reviews)
5.1
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks.

$83 USD in 3 days
(24 Reviews)
4.4
baigumair85

Hi. We are a team of two accountants with great hands on EXCEL and VBScript. We have more than 8 years of experience in Excel and can built this macro project very reliably and smoothly. Please join us in chat to discu More

$133 USD in 3 days
(17 Reviews)
3.8
nanda1208

I think I can help you on your project. I have large experience on Excel VBA and I can do this assignment for you. Feel free to contact me to discuss further details, my bid and deadlines.

$50 USD in 2 days
(14 Reviews)
3.4