Stock vs sales excel template

Hi, I am a Canberra-based software developer with significant experience in developing customised business solutions in Excel. I know you said you want a template to copy data into, however...if your data is always going to be in the format you have uploaded, you may well wish to consider a VBA solution (in case you aren't familiar Visual Basic for Applications is the integrated programming language within the Microsoft Office suite). With VBA, I could write a report generator that allows you to select the relevant files (using standard open-file type screens), imports the data and then allows you to click simple buttons that will sort and filter the data according to your needs. If this is something you are interested in, please feel free to PM me and we can discuss more.

Dear Employer, I have checked both of your sheets. One tells the data of both your stores and one tells downloaded products details and I understand you want to merge two sheets and apply filters to see stock vs sales for various categories. Please message me to discuss further. I have done countless jobs like yours. My previous reviews on Freelancer: https://www.freelancer.com/u/asin1987 Thanks and Regards, Ash

Hello, I can help you with your project - Stock vs sales excel template 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 already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

Hello, I am an Excel/VBA expert and I can build the template that you need for your reporting. Please check my profile and contact me to discuss further details. Regards.

Hello.... Greetings to you !! I have in-dept professional experience and have the ability to provide quality services to my clients.I can do your job . My skills :- * Ms Excel ( Proficient) ( Pivot table, Charts, Advance formulas, VB Code) * Web scraping * Data Entry and Research * Conversion (PDF to Excel, JPEG, XML, DOC,etc) * Virtual Assistant * Data processing My aim is to keep my client happy with providing accurate work within the time frame provided. There is no compromise on the quality and accuracy of work. Thanks & Regards Khushi

I can do it for you quickly and exactly .Please contact me for saving your time and your moneys .

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 260 projects successfully completed here. I can combine the reports, and create a tool that allows you to easily generate reports by any of the fields (gender, supplier, category). The results can be exported at the push of a button. I have many ideas that will make your work and analysis faster and easier, and i also have some questions. Contact me to discuss the details. Best regards

Dear client I understand the requirements in this project. I can make a template for you in excel wherein you will enter your data and in the next tab you will be able to filter category wise or supplier wise etc to check on your stock vs sales scenario. Also can provide filter for your store and warehouse. Kindly contact me and let's have a discussion on this. Roy

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred and twenty five excel vba projects in couple of years. Willing and looking forward to working with you. Thank you, Regards.

Hi, Would you like to see a quick demo of your combined reports with tabs and filters before you award the project? You can consider it professionally done in a few hours. I have vast experience working on similar projects and I am confident I can exceed your expectations. I am passionate about flawless results and I can assure you of a job well done. I can continue telling you about how highly experienced and qualified I am. But I’m sure you need more than that. Before you award this project, I can complete a sample of the job so you can be sure you’ve entrusted your job in the best hands. No commitments required! I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time.

Hi, Keen to work on this project and create the template for you. I am well versed with Excel and its various features like Userforms, Pivot tables, HLookup, Vlookup, Countif, SUMIF, Left, Right, Index Match, drop down, filters, charts, graphs, conditional formatting, mail merge, dashboards and can provide the Excel that you are looking for. If need be I can also do automation using VBA/Macros. I have done good amount of work in Excel macro handling. It includes userform creation, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. I have more than 15 years of working experience to my credit. I will be happy to answer any queries that you may have. Looking forward to your response. Thanks

Hi. I'm interested in your project about creating a template that shows stock vs sales for various categories (given date and filters). I took a look at your excel sheets and I did many projects like this if you interested too we could have quick chat about details on the project and your requirements. I have rich experience in VBA-Macro(Excel, Powerpoint, Access, Word, Web scrapping, API, ....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" # Time Commitment # Availability Thanks, Shahin

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 understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.

I'd like to be considered for your request. I am a data guy with a strong background developing several excel tools including vba automation and complex formulas and functions applied in excel and I can assure quality and accuracy in a short time based on your request. For more than 10 years i've worked on different sets of files having to deal with a lot of complex projects. I have a deep passion to finish in time every project that i am involved in. You can see my profile for better understanding what i was involved with. I highly evaluate professionalism and hold my self strictly accountable to fulfill my client need. I aim to form a great working relationship. Thank you for your consideration. Martin

Hi there, I have done similar work recently to provide a clear overview of stocks n different stores and warehouses. I can integrate data in the 2 reports to provide you the information you are looking for. Kind regards Reuben

Your Project Stock vs sales excel template got my attention and would love to offer my services. Hi there, it's me Anusha working as a Team Lead of Web Researchers and Web Miners at a Local firm here in Karachi, Pakistan named AUA Solutions (an outsourcing organization and ranked top 10 B2B and data solution provider in Pakistan). I have enough experience in web researching, data extraction, email extraction, data collection from any region of the world and LinkedIn Profile mining. I have Done BS-IT with Microsoft Office Specialist Certificate for Excel. Furthermore, I provide the following services: • Data Entry Any Type • Web Research • Data Collection • Copy Paste work • Retype Scanned document • PDF to excel retyping • Data Mining / Data Collection • Lead generation • Real Estate Research • Typing Work • Admin Work • Google Sheet • Manual Typing • All Work Related Excel / Spreadsheet • LinkedIn Profiles • LinkedIn Scraping • Email Extraction • Specify your requirements and I will work accordingly. Feel free to drop a message anytime. First we will discuss the requirements then you can place an order. Thank you for reading!

Hi, I am a Certified Public Accountant (CPA) and an expert in Excel / VBA application. I can help you with your spreadsheet and will deliver the project fast and accurate. Design will be based on your customisation. Contact me to discuss and I will start immediately. Regards!

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.

HI Happy to hear from you Only 300 AUD in 2 days-Lowest bid with a high potential solution I have gone through your current requirements & would be happy to offer you with the required solutions. I am a Certified in Excel, Google Spreadsheet, Data analytics. I am also an expert in building MIS as well as Professional Visual Dashboard I have attached my portfolio to know of the work done by me on excel/Google Spreadsheet.I have delivered so many sustainable & reliable dashboard in the organization with a turnover of over 100 billion dollars. Portfolio:https://www.freelancer.com/u/DHAVALPATEL008?page=portfolio&w=f&ngsw-bypass= With over 10 years of experience and has made more than 500 MIS/Dashboards in the various organizations and startups in the field of Chemical, IT, Pharma, Civil, FMCG I have Designed Template/MIS/Dashboard in the following field 1. Human Resouces(HR) 1.1 Time management 1.2 Payroll management 1.3 Employee Register 1.4 Recruitment 1.5 Training 2. Finance/Costing/Accounting 2.1 Balance sheet 2.2 Audit management 2.3 Profit & Loss Tracking 2.4 Investment vs return 3. Project 3.1 Project Planning & Tracking 3.2 Project Performace & Finance planning 3.3 Workflow management 3.4 Civil Contractor Work & Costing 4. Maintenance 4.1 Asset management 4.2 Daily Job management 4.3 Maintenance Planning & Execution 5. Procurement/Sales/Marketing 5.1 Material/Service Purchase requisition 5.2 Vendor Management 5.3 Stock management 5.4 Sales Planning vs Actual

HI, I AM A SOFTWARE PROFESSIONAL DEVELOPING SOFTWARE IN MS ACCESS WITH VBA FOR LAST 22 YEARS. I WOULD LIKE TO DEVELOP THE DATABASE IN MS ACCESS AS PER YOUR REQUIREMENT AND INPUT PROVIDED BY YOU. THE TASK WILL BE COMPLETED WITHIN A COUPLE OF DAYS. LOOKING FORWARD TO HEAR FROM YOU AT THE EARLIEST. THANKS, ALOKE SEN

Greetings, Throughout my 35+ years career, I have used Excel extensively to manage the programs / projects / actions and the reporting requirements. Normalized/cleaned up lot of data, collected from various sources and made it easily usable using Excel. Provided numerous solutions in Excel using advanced functions, formulas, Pivot tables, custom & conditional formatting and visualization using innovative Graphs & Charts. Please refer to my portfolio. Keen to take up this assignment. With this Bid Amount, I commit upto 8 hours of support. If the assignment gets over before that, we can use the remaining time for any other tasks you have. if proposed terms are the problem, we can discuss the same. Thank you for taking the time to read my proposal. Warm Regards