Macro for Customized Excel Report
$10-30 USD
Paid on delivery
Take data dump and format raw data into a customized report that is easy to read.
My steps in Excel: Open up raw data file (freeze top row) Format "Amount" column to currency Highlight all data and add grids (all borders around the data) Do a custom sort (in the following order): 1) Sort by "Fiscal Period" column using a (Custom List: Q1-2014, Q2-2014, Q3-2014, Q4-2015, Q1-2015, Q2-2015, Q3-2015, Q4-2015, etc) 2) Then sort by "Forecast Category" column using a (Custom List: Closed, Commit, Upside, Pipeline, Omitted) 3) Then sort by "Probability (%)" - largest to smallest 4) Then sort by "Close Date" - oldest to newest 5) Then sort by "Amount" column - largest to smallest Next I change the tab name from "Sheet 1" to "Pipeline (today's date) [url removed, login to view]" Then I create a pivot table on a separate tab and label the sheet as "Summary" Criteria for pivot table: Row Labels (Fiscal Period, Forecast Category) & Values (Sum of Amount in Currency format & Opportunity Name in Count format
Project ID: #8553210
About the project
20 freelancers are bidding on average $24 for this job
Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in few data analytics pro More
Hello, I have been working as freelancer since last ~ 4.5 years, prior to this was working with a MNC as a Sr. Software Professional. The project is Product based development and integration of the product with v More
I am very interested in your project. I have 5+ years exp. in MS Office, Designing, Quick-books, Office Management, PDF, Google spreadsheet, Vba and typing. I will give you my best possible work. I would like to thank More
Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA
I am an expert on Microsoft Excel and programing VBA macros. You will be very satisfied with my job,
I can provide you with the job completed tomorrow Saturday before 12 p.m. If you need any additional work, just let me know.
I will do my level best effort with my knowledge in excel. I assure you that you will be satisfied my my work
Dear Sirs: t is a pleasure to offer you my services to this project. I understand the importance of it, so I offer you to do a good job . Cordially yours, Nohemi Romero
Hello, I hope my message finds you well. I have a long history of VBA coding & data processing experience .. be assured that you project will be done with the best quality. Many thanks in advance :)
Hi, Please provide the opportunity to work with you. I will deliver the best output. Hope we will converse. Thanks in advance ! -- Thanks & Regards, Amit Anand
Hi, i am a professional in excel macros and VBA so i believe that i can deliver what you want in a very clear code.
