Automate excel spreadsheet and make form appealing
I need to automate the attached spreadsheet to do the following: 1 - Auto populate the "child listing" once the form is completed. 2 - Ability to retrieve information and populate form so it can be edited (i.e. search for child and edit list) as well as continue to add new children; 3 - Print button so it prints landscape 1 page fit as per current. 4 - Version for MAC and windows. 5 - Lock so only items highlighted in yellow are editable by user. Make front form look more appealing (if possible!). Spreadsheet overview: 1 - TAB 1 is form to be completed. 2 - TAB 2 is child listing. 3 - TAB 3/4 information used in formulas on TAB 1.
About Me
Hi, With a considerable 15+ years of industry experience in the areas of software development, data analytics, artificial intelligence (AI), and machine learning (ML), I am a highly driven software engineer. I have efficiently developed and delivered strategic software solutions to various companies by leveraging my technical background and analytical skills. Key Domains and Skills: * Modern Software Application Development: Experienced in building modern software applications adhering to standard best practices, including DevOps, test-driven development and agile planning. I focus on scalability and use common tech stacks such as NodeJS or Python to deliver robust, efficient, and maintainable software solutions. * AI/ML Engineer: A deep understanding of technologies like GPT, LangChain, LLAMA, FAISS, PINECONE, SciPY, Python, Pandas, NTLK allows me to build and deploy AI/ML models that can solve real business problems. I have developed AI-powered chatbots, ML models predicting customer churn, and natural language processing tools. * Python Web Scraping Pro: An expert in Python programming and web scraping, I create custom scripts for data mining and can handle dynamic web contents using JavaScript. Skilled in web scraping, data mining, data processing, and web search. I use scraping frameworks such as Scrapy, Beautiful Soup, Request and develop Python-based web and desktop applications for data visualization. * Automation Specialist: Possess deep expertise in designing and deploying complex, multi-step business process automations and workflows using modern no-code/low-code platforms, including n8n, [login to view URL], and Zapier. My focus is on connecting diverse systems—ranging from web applications and cloud services to internal tools like SharePoint and Dynamics—to achieve seamless data flow and process efficiency. I hold a commitment to delivering value-adding software solutions by continually exploring and learning the latest technological advancements. My approach to project management ensures a free demo as a proof of concept and technical support post-completion. With a customer-centric focus and a proven ability to develop innovative solutions, I am confident in my capacity to overcome challenges and provide invaluable contributions to your team and projects. Let's collaborate to turn your vision into a software solution that provides actual results.
