I need an excel expert

Hi There, I can help you to seperate all the data in to some sort of Pivot Table as like you say, i have many experience using excel over 10 years, please kindly chat me,' thanks. Regards.

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will transform your data from one format (sheet1) to another (sheet2). I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $100* and can deliver within a couple of days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 340 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

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 can definitely help you in this project. Kindly contact me. Roy

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards

I develop inventory modules in Microsoft Excel by VBA. I built modules which enable you to manage inventory transactions in a spreadsheet by Bill Of Materials, cost centers, currencies and to get immediate reports and info. The modules can upload external databases. There is a search engine with high search capability to find a specific record (or group). During the process, Excel validates the information and prepares reports and documents based on the needed parameters and criteria. There is a report generator which enables you to develop templates independently. And more, the files are secured by username login and password. I am a financial expert and a guru in Excel and VBA. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I develop financial modules including business valuation methodology & ratios. During my time serving as CFO, Controller, and Chief Accountant at different global parent companies, I gained knowledge and expertise in Financial Reports, accounting, consolidating, forecasting, and budgeting. I have experience in implementing information systems in organizations and businesses (accounting, payroll, treasury, budgeting and control, Intuit QuickBooks, SAP, ERP, etc.). Within a multi-currency environment and the global marketplace.

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Making the SKU column values are tricky it seems, as there are repetitions and they have been sequenced. Just clarify with a concise mini size input vs output. Willing to take up your project. Thank you, Regards.

Hi, I am an expert in Excel, I have checked the attached file and I can complete your project in 1 day using Excel Power Query. I am ready to start your project immediately, please send me a message to discuss further. Thanks

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully and checked attached file. I can develop a macro to get data from sheet1 and arrange them same as sheet2. I have done many similar projects so can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra

Hi, I have checked the excel sample that you attached to the project post and I can assist you to create the payhs for each part. Best regards, Florin Enache

Hi there, I saw that there are stacked data in your records and needed to be separated, each having a single row. Please tell me more about your data - how many rows of data do you have . we need to determine our best approach to solve the issue. I'll be standing by to help. Reggie

Hi Good Day! A serious freelancer here. I can help you to complete this project. I saw your file but need additional detail from you. Can you message so we can discuss it. I can make it automated using Excel Formulas and VBA Macro. Please consider my bid. I've done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. Message me anytime to discuss. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!

Hello, I have 15 years of experience working with Excel and VBA. I really appreciate getting to see a sample of the input and output required. Please, can you let me know why the 01-2242-P0 increases to 01-2242-P7 in the output but remains the same in the input, is this what should happen when the same part works with multiple bicycles? I notice that 12-52M-120 and 12-52M-120GD do not change so I just want to understand how the macro should be programmed. Thanks for reading this.

Hi hope you are doing well. I can make pivot tables as per your need. please explain what is majority options of numbers means? let me hear from you. thanks

I am very good in excel and it’s functionality. I would be able to get it done in 2 days time(max) . Hope that I will be selected for the project. I have 11 years of experience in using MS office products.

Hello, Thanks for reviewing my proposal on your project. I am expert in all type of data entry work (Ms Excel, Word, PowerPoint PDF to word excel conversion). I’ve more than 15 years’ of experience in document management. I’ve a passion for accurate data entry. I am looking for a long term relationship. If you award me a project I will prove myself as dedicated resource. I can give you a free sample of my work in a day. Regards

Hi, I'm interested in the project, I have extensive knowledge of Excel, I expect contact for more details.

Hi, I have few years experience with excel as a business analyst and financial analyst. I can do your job in max 2 days. Cheers,

Hello sir, I'm a professional freelancer with 2 years of experience. I can do this job because it is my expertise. Everything will be done within the time frame. Relevant Skills and Experience - data entry - microsoft words - microsoft excel - data processing - pdf I will make sure everything will rum smoothly. Any amendments are up to 2 times only. Feel free to message me.

Hi there! I am Baldwin Vargas, and I am a newbie here in the freelancing world. And it would be a real pleasure if you will be my first ever client. So I looked into the sample spreadsheet you attached herewith. And run it through the problem description and specs you indicated. From what I understood, you want to list down all SKU codes coming from the different product columns (those that come after Make, Model Name, Model Year columns). And across the SKU codes are their corresponding Make, Model Name, and Model Year. And what makes this task complicated is that SKU codes could be assigned to different Make, Model Name, and Model Year. And vice versa. Also, as you mentioned, some Make, Model Name, Model Year has no assigned SKU codes for all kinds of products. So I don't think there's any built-in Excel function that could produce your intended output. It is best to write a Macros to produce the output you specified. The basic design of the program is for it to cycle through all the SKU codes, row by row, and just outright print the corresponding Make, Model Name, and Model Year. We could probably extend the functionality into listing as well what kind of product is a particular SKU and sort them accordingly. I have an existing VBA project that does some of the things I mentioned above, and I can definitely reuse some of them. Will you give me the chance of working with you? I think I can finish this project in 5 days for $150.

With a good efficiency, I can complete this task in a needed time. I have some skills required to complete this task and otherwise I'm a hardworking person to complete this project.