
Cancelado
Publicado
I need custom Excel files to import and reformat inventory data from multiple spreadsheets. Requirements: - Current data organized by Product ID - Final file needs to include: - Product name - Quantity on hand - Part name - Mark number - Raw material code - Specific information related to each part Ideal Skills and Experience: - Advanced Excel skills - Experience with data manipulation and formatting - Attention to detail - Ability to work with multiple data sources
ID del proyecto: 39754814
183 propuestas
Proyecto remoto
Activo hace 2 meses
Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos

Hello, I’d be glad to assist with creating a custom Excel solution that imports, consolidates, and reformats your inventory data from multiple spreadsheets. I have strong experience working with Excel for complex data manipulation, including Power Query, VBA, and advanced formulas to automate the gathering of information based on keys like Product ID. My plan is to design a structured template where all relevant details—product name, quantity on hand, part name, mark number, raw material code, and related part information—populate consistently and are easy to review. I will ensure the final file is user-friendly, scalable, and accurately maps fields from different sources. I’m confident I can complete this efficiently and I’d love to chat in detail to confirm your exact workflow and expectations. Looking forward to collaborating on this project. Best regards!
$693 CAD en 14 días
4,3
4,3
183 freelancers están ofertando un promedio de $37 CAD /hora por este trabajo

Hi, I am an Excel Expert, with data manipulation, Formulas and Programming. I can create an VBA application to import multiple data sources and format the data as requirement. I can use pivot table to filter the data based on ID. Also, I can create a resultant file with the said titles for the report. Looking forward to discuss in the chat. Please initiate the chat. -Chandra
$25 CAD en 10 días
8,5
8,5

As an experienced and versatile full-stack developer, I possess all the skills needed for your project and more. Having worked with Metlife GOSC, DXC technologies and Elite Services, I've gained formidable skills in data manipulation and formatting, which will be crucial in reformatting your inventory data effectively. My profound knowledge of Excel incorporates not only basic operations but also complex functions like VBA, Macros, and Visual Basic, which are key components in processing large datasets efficiently. Above all, my experience is rooted in a relentless pursuit of 100% client satisfaction. And to reaffirm this commitment to you, I offer highly competitive rates while ensuring a speed of delivery that doesn’t compromise quality or attention to detail. Pay only if you're satisfied with my work - because for me, it’s about forging long-term relationships characterized by mutual success. Your project will benefit not just from my technical expertise but from my well-honed soft skills such as punctuality, attentive listening and effective communication – all crucial for understanding your specific needs. My customers testify that the anecdotal aspect of my service is unquantifiable and results unprecedentedly delightful. Choose me for a project done right the first time without any hassle or worry - let's get started!
$25 CAD en 40 días
8,6
8,6

As an Excel virtuoso with a knack for turning complex spreadsheets into efficient, user-friendly tools, I can assure you that choosing me for your project will result in a bespoke Excel Inventory Import Tool that meets and exceeds your expectations. Leveraging my advanced Excel skills and ability to work across multiple data sources, I'll ensure your current inventory data is organized optimally by Product ID and reformatted into a final file that includes, not just the basic requirements but all pertinent product information like quantity on hand, part name, mark number and raw material code. My expertise extends beyond Excel skills. I'm also adept at using tools like Google Sheets to create powerful, collaborative solutions. Additionally, my web development skills equip me to build any extra functionalities you may need as part of this tool. My strength lies not just in performing efficient data manipulation tasks but also in automating them so you can save time and effort. And because I value client satisfaction above all else, you can count on on-time project delivery without compromising quality. To summarize, hiring me means you're choosing imaginative solutions packed with creativity, precision and meticulous attention to detail – plus timely delivery. Hit the blue ‘Hire Me’ button now and let's embark on this transformational journey together!
$38 CAD en 40 días
7,9
7,9

"""""""""""""""""""ADVANCE EXCEL EXPERT/Custom Excel Inventory Import Tool"""""""""""""""""""""""" ""Sir, I can create a custom Excel solution that consolidates your inventory from multiple spreadsheets, organizes it by Product ID, and includes all required fields (Product name, Quantity, Part details, Raw material code). I’ll ensure clean formatting and accuracy for easy import. EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Certified business Accountant with more than 10 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 4 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, Power BI, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 400+ 5 stars reviews here. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Regards Arman Kakar "
$30 CAD en 40 días
7,6
7,6

With over a decade of experience as a Data Entry Specialist, I have comprehensive Excel skills that match your project description to a letter. My ability to manipulate and format data in Excel has been consistently praised by past clients for its accuracy and efficiency. You can count on me not only to organize your data based on the Product ID, but also to include all the necessary fields - from Product Name to Specific Information related to each part. In addition to my proficiency in Excel, I want to emphasize my ability to work with multiple data sources and the attention I always give to detail. I understand the importance of every field as it contributes to the overall value of your inventory system. From experience, I know that a small error in data entry can have significant consequences, which is why my work mantra revolves around accuracy for the sake of your business. More importantly, I want you to know that when we work together, you're choosing more than just an excellent freelancer - you're gaining a collaborator who's committed and dedicated with full trust and confidentiality. My ultimate goal is your 100% satisfaction so let's kick start this project and make your data work for you!
$30 CAD en 40 días
7,0
7,0

Hi, Are you tired of juggling multiple spreadsheets and still not getting the data you need? I specialize in creating custom Excel import tools that streamline data from various sources, ensuring accuracy and clarity in the final output. Let's discuss how I can transform your inventory data into a seamless and organized format. Best, Smith
$38 CAD en 40 días
7,1
7,1

Hello, I’m excited to offer my expertise to help you achieve your project goals. As a Certified Project Manager and Expert Trainer with a proven track record at Zayer Tech, I specialize in delivering tailored solutions that drive efficiency and innovation. My team and I bring a unique blend of project management expertise and AI-driven capabilities to streamline processes and enhance outcomes. What I can offer: AI Integration & Automation: From no-code/low-code tools like Zapier and Power Automate to custom workflows and API integrations, I optimize business efficiency. Documentation Excellence: Comprehensive project proposals, business plans, SOPs, and technical documentation, all crafted with precision. Digital Marketing Mastery: Targeted strategies, SEO optimization, and brand growth via social media and paid ads. Web & Content Management: WordPress design, e-commerce integration, and content optimization tailored to your audience. Project Management Expertise: Agile methodologies, resource planning, and stakeholder engagement to ensure project success. With advanced proficiency in tools like JIRA, ClickUp, Slack, and Figma, I ensure seamless collaboration and real-time tracking to meet your deadlines and expectations. Let’s collaborate to transform your vision into impactful results. I’m eager to discuss how my skills align with your project needs. Thank You
$25 CAD en 40 días
6,8
6,8

Hi, I create reliable and efficient Excel automation using VBA macros and advanced formulas customized to fit your exact needs and workflow. What I Can Help You With: Excel Automation & VBA Development VBA Development Excel Macros Automation Complex Formulas Custom Functions Dynamic dashboards, charts, and visual reports Pivot tables & data summaries Automating Repetitive Excel Processes with VBA Macros Custom Excel spreadsheets tailored to your needs Generating PDF Reports from Excel Data Converting PDFs to Excel Worksheet
$30 CAD en 40 días
6,7
6,7

Hello, I have reviewed your project details and understand that you need custom Excel files to import and reformat inventory data from multiple spreadsheets while keeping everything organized by Product ID. With expertise in Excel, VBA, and advanced data manipulation, I can build a solution that streamlines the process and ensures accuracy. I will begin by designing a structured import process that consolidates your spreadsheets into a single file. Using Power Query and VBA macros, I will automate the reformatting so fields like product name, quantity on hand, part name, mark number, and raw material code are properly aligned. Next, I will implement checks to ensure data integrity and apply formulas or macros where necessary to highlight inconsistencies. Finally, I can enhance the file with a clean layout and optional visual summaries for quick insights. Would you like me to also include an automated refresh button so new files can be added seamlessly in the future? Let’s connect to get started. • Ready to see why I'm the right fit for your project? Head over to my profile for client reviews and a glimpse of my portfolio: https://www.freelancer.com/u/ShaikhAneesa/Excel-Automation Best Regards, Aneesa.
$25 CAD en 40 días
6,7
6,7

Hi there, My name is Isme A., Project Executive at 8veer Consultancy. Thank you for considering us for your Custom Excel Inventory Import Tool project. We understand your need to consolidate and reformat product data from various spreadsheets into a unified file structured by Product ID, including key fields like part name, quantity, mark number, and raw material code. Our team will develop a streamlined Excel tool with advanced formatting and macro functions to automate data import, ensure column accuracy, and flag inconsistencies for validation. We’ve built similar solutions for inventory teams in manufacturing and retail, resulting in faster reconciliations and reduced manual handling. We estimate delivery within 3 working days and are ready to begin once sample sheets are received. Yours sincerely, Isme A., Project Executive Project Management Office (PMO) 8veer Consultancy Ref: 8V-PMO-FRC
$40 CAD en 30 días
6,5
6,5

Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards.
$40 CAD en 40 días
6,2
6,2

Hello Andrew E., I have read the project details and understood the overall requirement. I am Abdul, with 5 years of experience in Visual Basic, Data Processing, Data Entry, Excel, Excel Macros, Data Cleansing, Data Visualization, Data Analysis, Data Integration, and Data Management. I have successfully delivered multiple projects in this domain. For the Custom Excel Inventory Import Tool project, I will utilize my advanced Excel skills to create custom files that efficiently import and reformat inventory data from various spreadsheets. By organizing data by Product ID and including essential details like Product name, Quantity on hand, Part name, Mark number, Raw material code, and specific part information, I will ensure a comprehensive and accurate final file. Please review my portfolio: https://www.freelancer.com/u/mannanmaan1425 and feel free to connect with me to discuss the project further. Best regards, Abdul
$25 CAD en 40 días
5,6
5,6

Hi Andrew, Thank you for considering my proposal. With over 8 years of real-world experience and freelance work in Excel, I am confident in my ability to assist you with your project. I have carefully read through your requirements for a Custom Excel Inventory Import Tool and believe that my expertise aligns well with what you are looking for. I would like to connect with you in chat to discuss your project further and ensure that I can provide a tailored solution to meet your needs. Regards
$25 CAD en 40 días
6,0
6,0

Hi there, I am happy to see this straightforward project and immediately available to get the data from multiple excel to templates perfectly. Good in excel and shortcuts. I can do this task quickly. Waiting for your message. Thanks
$25 CAD en 5 días
5,6
5,6

Hello, I understand you need a custom Excel solution to import, reformat, and organize your inventory data from multiple spreadsheets. With advanced Excel expertise and strong experience in data manipulation, I can build a streamlined file that consolidates all your product information into one structured, easy-to-use format. I will ensure that your data is properly aligned by Product ID and that the final file includes every required field—product name, quantity on hand, part name, mark number, raw material code, and all part-specific details. My approach is detail-oriented and designed for accuracy, so you can trust the data will be clean, consistent, and ready for reporting or further use. I’d be glad to set this up quickly so your inventory data is both reliable and easy to manage moving forward. Best regards, Mussadiq Hussain
$30 CAD en 40 días
5,1
5,1

Professional Excel developer ready to do the required Custom Excel Inventory Import Tool. Check skills, experience, and clients reviews in the links below. Regards, Rageh https://www.freelancer.com/projects/excel/Excel-Auto-Execute-Macro-Upon/reviews https://www.freelancer.com/projects/excel/Fix-excel-VBA-36198376/reviews https://www.freelancer.com/projects/excel/Excel-Macro-Magic/reviews https://www.freelancer.com/projects/data-processing/data-processing-use-mail-merge/review
$25 CAD en 40 días
5,2
5,2

Hello, I am excited to assist you with your project to create a Custom Excel Inventory Import Tool. With advanced Excel skills and extensive experience in data manipulation and formatting, I can ensure your inventory data is organized and reformatted precisely as you require. I understand the importance of structuring your final file to include all necessary details: Product ID, product name, quantity on hand, part name, mark number, raw material code, and specific information for each part. My meticulous attention to detail will guarantee that all data is accurately processed and seamlessly integrated from multiple spreadsheets. With my proficiency in Excel, including macros and data cleansing, I am confident in delivering a solution that meets your expectations and enhances your workflow. Thanks, Monicah
$25 CAD en 9 días
5,2
5,2

I am sure you will give me more projects after this. I have done a similar project a week ago. I am interested to do this project too and ready to complete this within the timeline. Pls check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Note: Budget Negotiable.
$38 CAD en 40 días
4,9
4,9

Hi sir, I have a lot experience I can be the best for your project. I will do this project without any mistake. You can trust me. Please give me a chance so that I can show you my skill and tell you about my hard work.
$25 CAD en 40 días
4,6
4,6

As an Excel aficionado, my unique blend of skills and extensive experience in data analysis and manipulation make me a highly accomplished choice for your project. With over eight years of working with Excel, I am proficient in not just Excel functions, but also in PivotTables, macros and VBA scripting for automation. Your requirements align beautifully with my expertise as evidenced by my track record of automating data-related tasks using VBA, Power Query to improve workflow efficiency; skills that will allow me to design you a custom Excel tool specifically tailored to your needs. One of the things that sets me apart is my ability to understand the critical details within enormous sets of data and to transfer these interpretative findings into clear, actionable insights. My data transformation and cleaning skills using Power Query can assist in structuring your inventory data such that it is easily accessible and manipulable. Together with my advanced analytical thinking approach to problem-solving, your data will be handled accurately and effectively, without a single omission or error. Let's connect on this project.
$25 CAD en 40 días
4,6
4,6

Stoney Creek, Canada
Forma de pago verificada
Miembro desde mar 31, 2021
$15-25 CAD /hora
$250-750 CAD
$250-750 CAD
$250-750 CAD
$15-25 AUD /hora
₹750-1250 INR /hora
$250-750 USD
$15-25 USD /hora
$30-250 USD
$10-30 USD
$750-1500 USD
₹12500-37500 INR
₹12500-37500 INR
$15-25 USD /hora
$10-30 USD
£20-250 GBP
€250-750 EUR
$10-30 USD
$30-250 USD
₹600-1500 INR
$30-250 USD
$15-25 AUD /hora
$250-750 USD
$30-250 USD