create a macro and excel DB to capture statistics
$30-250 CAD
ชำระเงินเมื่อจัดส่ง
Hi
so the idea is to have one excel document (this will be the "master doc" that will have one page doc., and this master doc will be split into two parts - one part will be offloading, another part will be onboarding. when someone is onboarding they will click onboarding and it will only show info regarding onboarding content (this will be a simple macro with one click), and when they click offboarding it will show only offboarding material. Once they complete the required doc and hit send it will go to two seperate email addresses or one (I have to decide which one at the moment).
the idea is on the second tab of this same I want to capture, the following info
- how many onboarding and offboarding were complete up until now, and specific data (check marks) were checked and those not checked by the individual. Now i will leave it up to you to see what is easier..this doc will be stored on sharepoint, where everyone can access, but no one can see the master doc statistics page that will only be seen by myself.
options are: - create same document within the same folder which will in sharepoint to be able to read and feed into master doc for statistics, or create new tabs each someone onboards and offboards, which will feed into one tab..whichever is efficient and easier..
the entire idea is to capture statistics in a dashboard form..even if have to use tableau.
let me know and we can discuss more.
Thanks
หมายเลขโปรเจค: #23334333
เกี่ยวกับโปรเจกต์
freelancer 13 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $139
Hello, I can help you with your project - create a macro and excel DB to capture statistics I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have เพิ่มเติม
Hi, I can code a set of VBA macros to do this and use outlook to send the email. But the logic need more explanation and a sample Excel file with data will help. Thanks
Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL เพิ่มเติม
Hi, I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel macro เพิ่มเติม
Sir, I am well versed in these kind of jobs and can do your project as per 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 y เพิ่มเติม
Hello. I've just read your note carefully. As far as i am concerned i am appropriate for you. I am a new freelancer but I've developing Excel , Access and VB and office for many years. Waiting for your reply.....
Hello, I am an Internal Tool and Automation Engineer by profession. I have been working with Python ,R, Excel and Web Development for the past 7 months. I also have a decent experience in Arduino ,Rpi ,Beaglebone and เพิ่มเติม
Hello Dear, I understand your requirements and it will be done in 2 days from my side. please drop me a message or contact me on 9594316971 for further discussion. Thanks & Regards, Surekh
Hello! My name is Tiago and I've been working with Excel Macros for the past 4 years. From the project description, I can see that I've worked with similar tasks, where I've used macros as a data entering method, which เพิ่มเติม