Excel Macro Development
$250-750 AUD
Πληρώθηκε κατά την παράδοση
I require a template report I have created to be populated automatically each month from a pivot table, which I also create. I currently populate the data into a report manually which is very time consuming as I have up to 60 Vendors.
- currently I create a dataset at the end of each month that includes the sales for all vendors off our e-commerce website
- I then translate this data into a pivot table
- then I manually cut & paste each Vendor and their relevant sales summary data into a template report
- that report is then saved to PDF
- this process is repeated for each Vendor (1-60 vendors p/m)
DEVELOPMENT REQUIREMENTS
I require an Excel macro to be developed to automate the above process. To automate the data populated into my report template from a 'pivot table. I see the development to include:
a) read the pivot table data and loop through each Vendor (max 60 vendors) and their relevant summary sales data
b) for each vendor automate the copy and paste of the data into the template report (supplied)
c) then save the report to PDF file format and move onto the next vendor
I have attached a file which includes several worksheets... The "Report" worksheet must be populated by data from the "Pivot" worksheet OR "Vendor Data" worksheet (either is fine).
*NOTE - if the pivot table or Vendor data worksheets need to be slightly altered in layout to make the macro development work, that is ok. The REPORT template must remain unchanged in format/layout.
Development must be compatible with MAC and MS Excel 2011 for Mac.
Ταυτότητα Εργασίας: #18249737
Σχετικά με την εργασία
Ανατέθηκε στον:
I am an Excel and VBA specialist. I have a lot of experience in creating automation tools, dynamic dashboards and macros in Excel. You may check some of my projects here: [login to view URL] Περισσότερα
14 freelancers κάνουν προσφορές κατά μέσο όρο $320 για αυτή τη δουλειά
Hello, I am Excel and VBA expert. I can do this project (VBA macro). If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects.
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar Περισσότερα
Hi, I have checked your project description and attached Excel sheet, I will develop the macro for you which will fulfill all the requirements mentioned in the project. I have expertise in Excel, VBA macro and dat Περισσότερα
"Hello Dear, Yes, I can work for you as per your project description with amazing exploration and experimental research abilities of mine organization is perfect for that you may require. My work fulfills as well as Περισσότερα
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.
Hello. I have good skills in Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps. I have checked your project description carefully and i think i can do your project. Contact me please. Thank y Περισσότερα
i am expert in data entry and visual basic i did work on many data entry projects your satisfaction is my priority lets see more in chat
I am sure I am the right person to do your work. I assure you the quality of output in timely manner. Have a good day! Thanks!
Hi my name is Gerardo and I can work on your task after office hours during US eastern time. I have almost 15 years experience in Python, Full Stack, Django, Data Analytics, ETL, SSIS, Qlik, SQL, VBA, report develop Περισσότερα
Excel Programmer I have advance Excel skills, I can create complex formulas and pivot tables. I also have a background in VBA programming which I believe is very useful in automating repetitive work processes. My ski Περισσότερα
I can do this project to give a quality output within the SLA. I have the experience to handle this project.