Excel Vba Programmer Malaysia Projects
Looking for freelance Excel Vba Programmer Malaysia jobs and project work? PeoplePerHour has you covered.
Create chatgpt bot scraping content from PC
Seeking programmer to create ChatGPT bot to self train on my data in my PC in word, pdf, excel and ppt, and also outlook. And use that to generate responses on chatgpt 4. Every day new files will be added to the folder. The bot needs to retrain whenever new file is added or when manually prompted. Must have experience with ChatGPT, content scraping, etc. Urgent start, 2 day turnaround needed.
20 days ago10 proposalsRemoteopportunity
A programmer to develop a website where users can buy eBook
We are seeking a skilled programmer to create a user-friendly website where users can buy electronic past questions and eBooks. The website should have a modern design, intuitive navigation, and robust security features to protect user privacy and copyright. The programmer will be responsible for developing the website's front-end and back-end components, including the user interface, database management, sign on to purchase ebook and payment processing. They will work closely with our team to define the requirements and specifications of the website and ensure that it meets the needs of our users. Key Skills and Qualifications: - Strong experience in web development, including HTML, CSS, JavaScript, and PHP - Knowledge of database management systems, such as MySQL or MongoDB - Experience with eBook sale processing and conversion technologies, such as ePub or PDF - Excellent problem-solving and communication skills - Ability to work independently and as part of a team - Attention to detail and a commitment to quality If you are a talented programmer with a passion for creating innovative and user-friendly websites, we would love to hear from you. Please submit your resume and a portfolio of your work for consideration.
18 days ago45 proposalsRemoteEducation Admin support
We are a small team of Healthcare Professionals offering a 1-yr Certificate Programme in Psychedelic Practice. This is aimed at Healthcare Professionals worldwide. We will likely be expanding to offer other courses over the coming years(s) Website: https://www.psyedu.co.uk/ Our current Education Admin Lead is leaving in May. We need someone to work flexibly around 3-6 hrs a week (10-20hrs per month) doing basic administrative tasks for our Education Organisation. It will be very busy between June and September (more like 6hrs per week) then will calm down a bit at other times in the year. We are a small start-up in our second year, just beginning to settle into our rhythm and we now need reliable low-level input which will likely slowly increase in workload over the next 3-5yrs. Job Description Skills/knowledge: MUST HAVE: Excellent written and spoken English, Organisational Skills +++, Microsoft office, excellent written and spoken communication skills, an understanding of the course we offer or a willingness to learn about it DESIRABLE: some knowledge of healthcare and how psychedelic practice is starting to be used in healthcare Qualities: flexibility Experience: any role which demonstrates the capacities outlined below Hours: 10-20hrs per month, ideally 1-2hrs on Mon, Wed and Fri each week Job Description: Key Responsibilities: 1. Communication Management: o Serve as a primary point of contact for internal and external communications. o Handle incoming emails, and redirect them as appropriate. o Draft and distribute notices, tutorials, open events and announcements. 2. Administrative Support: o Assist in scheduling appointments, and meetings for management and staff. o Maintain and update company databases, records, and filing systems. o Prepare and distribute documents as required. o Liaising with different organisations 3. Documentation and Recordkeeping: o Ensure accuracy and completeness of documents, contracts, and agreements. o Maintain confidentiality of sensitive information and handle it with discretion. o Organize and archive records in accordance with company policies and regulatory requirements. 4. Team Collaboration: o Collaborate with colleagues and departments to support cross-functional projects and initiatives. o Provide administrative assistance to various teams as needed. o Foster a positive and cooperative work environment through effective communication and teamwork. o Attending meetings once every two weeks 5. Problem Solving and Decision Making: o Identify issues or challenges in administrative processes and propose solutions for improvement. o Prioritize tasks and manage time effectively to meet deadlines and goals. Qualifications and Skills: · Proven experience as an Administrator or similar role. · Proficiency in office software applications, including word processing, spreadsheets, and presentation software. · Strong organizational and multitasking skills with attention to detail. · Excellent verbal and written communication abilities. · Ability to work independently and collaboratively in a fast-paced environment. · Discretion and professionalism when handling confidential information. · Problem-solving and decision-making skills. · Flexibility and adaptability to changing priorities and tasks.
8 days ago36 proposalsRemote
Past "Excel-vba-programmer-malaysia" Projects
opportunity
QuickBooks & Xero to Microsoft Excel Coding Expert Wanted
Are you an experienced coder with a knack for seamlessly integrating financial data from Xero and QuickBooks into Excel? We're seeking a skilled individual to develop a custom solution that will streamline the process of downloading financial information and populating predefined Excel templates. Key Responsibilities: 1. Develop a solution that allows users to select clients from Xero or QuickBooks directly within Microsoft Excel. 2. Enable users to choose specific types of reports such as Balance Sheet, Profit & Loss, Trial Balances, and more, all from within Excel. 3. Design a system that automatically feeds the selected data into predefined Excel worksheets, ensuring accuracy and efficiency. Requirements: 1. Proficiency in coding languages such as Python, VBA, or similar, with a focus on integrating APIs (Xero and QuickBooks). 2. Expertise in working with Microsoft Excel, including creating dynamic user interfaces and automating data entry processes. 3. Experience in developing custom solutions for financial data management and reporting.
pre-funded
I need some Excel VBA code correcting
Hi, I'm trying to finish a macro which will clear a selection of cell details, using ClearContents. I've got the selection of the cells written and runs fine, but keep returning an error on the second half of the macro - clearing contents. Error returning 1004 Code: Sub ClearContents() Dim rng As Range With Worksheets("Proforma") Set rng = Union(.Range("H13"), .Range("H14"), .Range("H15"), .Range("A23"), .Range("G23")) End With rng.Select rng.ClearContents End Sub Successful applicant will have VBA knowledge and able to provide the correct, working macro code. Thank you
pre-funded
Automate two Excel Files
I need to automate the following process in Excel using VBA. File 1 This is a reference file. See attached. Users can add/delete from this. File 2 File 2 is the Excel Master Template. In worksheet 1, there is a measure name in column A and a table with the 12 months of the year, split by quarter in columns B,C,D and E. The measures or tasks that people do in their day get manually input by TLs each month in the respective cell of the month against a measure line in cell B3, B4, C3, C4 and C13, C14 etc., TLs can manually update other cells that are not relevant to this exercise. In addition, there are 12 other tabs in this file, one for each month. Each of these tabs has its own tables with data in them that people manually enter. Format of these tables are the same for each month tab. These two files are saved in the same folder. TLs currently open File 2, go to worksheet 1 and manually insert the task or measure that they did each month. For example, they will update figures and text cell B3 for January and in C2 for February and so on. They can also update tasks that they hope to in future months. TLs update this same information again in the corresponding monthly tab. I want to automate this process using VBA. Pick the information from worksheet 1, say, cell B2, B3, B4 for January and copy the information into cell B33, B37, B28 etc., in the January tab. However, any other information that already exists in the monthly tabs in other cells that has been manually input should retain that information irrespective of the macro. They manually input the individual reference number and name in columns B1 and B2 of these monthly tabs. This needs to be automated using VBA using predictive text and populated to all the monthly tabs. In simple terms: Open file 2, pick reference data from 1 and populate cells in B1 and B2 in 12 monthly tabs. Then run VBA and take information from worksheet 1 and insert into specific cells in their coo corresponding monthly tab. Have a ‘Save As’ option defaulted to where File 2 was picked with the file name defaulted to the reference name picked. I use Office365 at work and my data is confidential. Therefore, I have created two dummy data files in Excel for you to work on. I have to replicate what you do in my work computer. Therefore, I must be able to re-type the VBA code at work. My suggestion is to create an Update tab for this as per File 2. Happy to look at alternatives. For someone with good VBA skills, this isn’t a difficult/time consuming job. So, if the VBA code need to change by a single line, I don't want you to charge me for an hours work! Timeline is roughly to have a demo version within three/four days and a permanent solution within one/two weeks max as I have to juggle any testing around my day job and possible yours. Thanks, Prasad.
opportunity
Modifications to Excel VBA Program
User requires enhancements to an Excel VBA program, String Match Correction, written for Excel 2010. The Program performs search, logic and comparison operations, metrics and scoring, and string manipulation between two Excel music data spreadsheets. The enhancements are required to accommodate a newly developed spreadsheet (Singles) and changes and additions to the field names of existing (AlbumCD and Tapes) spreadsheets. The task involves developing new VBA coding, integrating and modifying existing VBA coding to expand the automated spell checking, data comparison, metrics, scoring, and data editing features of the VBA Program’s functionality for the three Excel data spreadsheets, Tapes, AlbumCD, and Singles. Contact Buyer for spreadsheet and current UI views
pre-funded
Need 10 promotional leaflets to for social media advert post
1) I need 10 promotional leaflets created similar to these ones attached (example 1- with this blue, yellow and white, black colours ) and another one with predominantly a white colour background with touches of yellow and blue colour(another poster example will be sent to show example) . Please replicate the information from Dr Nick (the man ) poster (called Youth and Moms project) using the design style and colours and from the Dr Adeshola Cole's poster(example 1- name of the file) The headline of the poster will be called YOUTHS & MOTHERS Empowerment project. a paragraph to be inserted saying 'Join us instantly learn excellent tips and strategies to support and empower your child to achieve their full potential in school and life'. Free meeting (insert a zoom logo) Thursday 7.30PM (UK TIME) to 9PM CHINEDU Mentor Please Register at Follow us (facebook) @Chinedu-m insta@ @Chinedu-m www.chi/events I should be able to post it as an insta or facebook post to advertise and event for the above please use my picture below and flip it (rotate it) round so I am looking towards the left side. this needs to editable content so I can make future alterations to the text. Hope we can work on this exciting project for the 2 posters 2) I need another flyer saying the below YOUTH MENTOR PROGRAM BY CHINEDU Do you want to transform your mindset from a lack to an abundance mindset by a man of great life experience? If yes, this programme is for you. Empowering young men to become high value men within 90 days with excellent wisdom that can change the lives of many. The picture for this will be the full body picture with shoes 3) a 4th flyer saying UNLOCK YOUR POTENTIAL this below: Build Self-Confidence , Self-Worth and Self Love : Join my workshop. The workshop is designed to empower and support young people, particularly those from underprivileged backgrounds, in achieving their academic, career, and personal goals. My images for the flyer are IMG_6558.JPG and IMG_6620.jpg The reference example flyers are below (Dr Adeshola Cole, Dr Nick, Eno Eka
opportunity
Require a 'Google Maps' type of geographical list of companies
I require a programmer, who is able take an Excel business list, and be able to input it to an interactive map, displayed here: https://snazzymaps.com/style/15/subtle-grayscale. Also these entries would need some small interactive feature to help one business from one another (would need to discuss to go over details). The fee will have very little leeway for negotiation.
Excel programming, table evaluation
We are looking for someone who can create a small macro or VBA script or something else for us to create an Excel table with evaluations from a text file. The data needs to be sorted automatically and simple calculations like multiplication and sums need to be done. The data is working hours that we have to evaluate every month. 1. The total monthly working hours per person should be calculated and be rounded down to a full hour. 2. 30 minutes should be subtracted from the daily working time. 3. The total monthly working hours should be multiplied by a fixed value. 4. Finally a fix amount must be subtracted.
opportunity
Excel CRM programme - debugging & new forms
Excel debugging required plus: - existing manufacturing gantt chart to also be loaded on dashboard page - debugging of all user/data entry forms - create windows install .exe file to download programme - ensure no error messages show and file does not 'stop' if any user errors - Adjust and debug code to allow printing (pdf) of - sewing sheet, Order breakdown, SO, PO, BOM & Delivery note - Adjust and debug code to allow printing (pdf) of Design Sheet and saving copy to folder in One drive - create code to email customers/contacts direct from programme (adding attachments, ie. Design Sheet etc)
Excel Automation Expertise Needed
I'm looking for a highly skilled freelancer to assist me in automating tasks within Microsoft Excel. My goal is to efficiently manage and process basic data and return optimal results as well as a visual. related specifically to manufacturing foam blocks. Ideal Freelancer Skills: - Proficient in Excel VBA and macros - Experience with automation of data tasks - Knowledge of manufacturing industry a plus - Detail-oriented and analytical thinker Project Requirements: - Ensure accurate interpretation of manufacturing data - Generate solutions for rectangular and custom-shaped blocks processing Specific request: We are a foam manufacturing company and we cut foam to size from very large blocks on saws. We typically calculate the size to cut manually on the factory floor using the hard copy sheets (see attached). I would like to have an excel sheet to essentially mimic these sheets where you input the 3 sizes of the foam we'd like to cut and then the results will show the factory floor how to cut the block as well as showing a visual to the factory workers on how to actually make the cuts- basically creating these sheets in excel. Please let me know your thoughts on cost - this is likely more of a presentation basis than programming, but we will need some formulas and graphics to calculate and show the best way to cut the block and best way to to "yield" pieces from the block BLOCK SIZE IS ALWAYS 40 X 80 X 108 INCHES. There will likely be a couple iterations of this to get to completion.
Need 4 promotional leaflets to for social media advert post
Greetings, 1) I need 2 promotional leaflets created similar to these ones attached (example 1- with this blue, yellow and white, black colours ) and another one with predominantly a white colour background with touches of yellow and blue colour(another poster example will be sent to show example) . Please replicate the information from Dr Nick (the man ) poster (called Youth and Moms project) using the design style and colours and from the Dr Adeshola Cole's poster(example 1- name of the file) The headline of the poster will be called YOUTHS & MOTHERS Empowerment project. a paragraph to be inserted saying 'Join us instantly learn excellent tips and strategies to support and empower your child to achieve their full potential in school and life'. Free meeting (insert a zoom logo) Thursday 7.30PM (UK TIME) to 9PM CHINEDU Mentor Please Register at Follow us (facebook) @Chinedu-m insta@ @Chinedu-m www.chi/events I should be able to post it as an insta or facebook post to advertise and event for the above please use my picture below and flip it (rotate it) round so I am looking towards the left side. this needs to editable content so I can make future alterations to the text. Hope we can work on this exciting project for the 2 posters 2) I need another flyer saying the below YOUTH MENTOR PROGRAM BY CHINEDU Do you want to transform your mindset from a lack to an abundance mindset by a man of great life experience? If yes, this programme is for you. Empowering young men to become high value men within 90 days with excellent wisdom that can change the lives of many. The picture for this will be the full body picture with shoes 3) a 4th flyer saying UNLOCK YOUR POTENTIAL this below: Build Self-Confidence , Self-Worth and Self Love : Join my workshop. The workshop is designed to empower and support young people, particularly those from underprivileged backgrounds, in achieving their academic, career, and personal goals. My images for the flyer are IMG_6558.JPG and IMG_6620.jpg The reference example flyers are below (Dr Adeshola Cole, Dr Nick, Eno Eka
Require a 'Google Maps' type of geographical list of companies
I require a programmer, who is able take an Excel business list, and be able to input it to an interactive map, displayed here: https://snazzymaps.com/style/15/subtle-grayscale. Also these entries would need some small interactive feature to help one business from one another (would need to discuss to go over details).
Web scraping (URL) with VBA
Hello, I have an e-commerce website (not create by myself and no real database), I was able to extract main product information in CSV but I still need the URL 'page for each product to use for SEO and redirection. I would like a VBA macro using my website adress, using the product description, copy/paste them in google and extract the URL of the first product found (99% of chance to be mine). I can use VBA for some work but I cannot use it to be connected to google, internet... I can provide an excell sheet with website adress and product description, Column A : www.classic-red.fr Column B: product description in french, Column C: www.classic-red.com, Column D: product description in English. Expected, Column E: URL for french version, Column F: URL from english Version. Tell what you think and I am open to other ways as I am able to use it. regards regards, xavier
Excel VBA Expert needed to create Macro
I'm looking for someone who has a very strong command of Excel; including VBA, Power Automate, and Power Query to support the work of my company's Information & Data Teams. The initial project is focused on writing a VBA Tool which will convert a matrix (manual raw data) into a column vector for use in another tool. The input and output formats are specified and we need a tool which automatically transforms the data.
Looking for a Python Developer for Stock Market Analysis
Looking for a developer who have experience in Indian Stock Market and can get live and historical data by using python (non API or API method to get data). Knowledge of python, excel, vba.
Require a 'Google Maps' type of geographical list of companies
I require a programmer, who is able take an Excel business list, and be able to input it to an interactive map, displayed here: https://snazzymaps.com/style/15/subtle-grayscale. Also these entries would need some small interactive feature to help one business from one another (would need to discuss to go over details).
opportunity
Network chart across 4 buildings detailed
hi we have three builldings and we need to created a password protected network chart which includes 4 sites the chart needs to highlight our firewalls routers switches cctv recorders ups systems and visualistaion of racks we need to enter details such as ip addresses and vpn routes and poiint to point cable runs with numbering and so on it has to be a very indepth document which will also cover 4 individual sites with site contact details supplier details for broadband and it support services with contract numbers also need to document on there individual pc and licences for each pc connected to the network programme needs to be made so we can add and remove items ourselves easily the pages will also need to look good we would need this in an easioly editabel excel format and maybe a cad and pdf or oter similar files
General IT support; Set-up of new webdomain to DNS server
I am looking for a practical IT-consultant, who can assist with basic IT-support ad-hoc for a small business. Support is needed on a running basis when need arises for configuration of email, Word, Excel, virus protection and other simple business programmes; e.g., installing version upgrades, bug fixing etc. I would like to meet you over a short introductory Zoom meeting. During this meeting we shall present ourselves and you are to guide me on how to set up a new domain (hosted with the registrar) with the DNS servers of the host of the website. I will not provide log-in details to the system, but instead I want you to guide me while we share screen. This PPH project is for 60 min worth of IT support, i.e., the Zoom meeting and set up of domain explained above. I am looking forward to hearing from you. Thanks