Excel vba open files folder jobs
We need to have the 2024 Rate card converted to an Excel sheet. They have discounted rates by 12.5% for Platinum Winter and 15% for Gold Winter, as shown in a column.
I need a logo for my welding and fabrication... reflecting the nature of the work we do. Key Points: - The design should be modern and sleek, while still embodying a classic and traditional rustic and industrial style. - Creativity is key, as I have not specified particular elements to include in the logo. However, the designer's understanding of the field may inspire the incorporation of relevant elements. - As for color scheme, I'm open to suggestions. However, a mix of metallic shades and earth tones could work well. Skills and Experience: - Proven experience in logo design, particularly in the industrial sector. - Strong understanding of both modern design principles and traditional rustic aesthetics. - Excellent communication skills for discussing design ...
...Information: i. Contact Person’s Name ii. Contact Person’s Title iii. Mobile Number iv. Main Number v. Email Address 2) Specific NGO Focus: Ensure the search targets Muslim-based NGOs only. 3) Use array aggregation to optimize credit usage, grouping multiple data points into a single data object. 2. Output Requirements: 1) Export the aggregated data into Excel format. 2) Automatically upload the Excel file to a designated Google Drive folder. 3) Provide sample outputs for the following locations: a. Malaysia, Selangor b. Indonesia, Jakarta c. Thailand, Bangkok d. England, London 3. Documentation: 1) Create a Microsoft Word instruction manual covering: a. How to run the workflow. b. Adjusting search parameters for countries, states, and categories. c. En...
I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both imported data and DirectQuery modes.
I'm seeking a professional who can assist me in migrating my e-commerce site from WooCommerce to a better platform. The current WooCommerce platform has become bloat...who can assist me in migrating my e-commerce site from WooCommerce to a better platform. The current WooCommerce platform has become bloated with too many plugins, which has led to performance issues. I need a new platform that is efficient, easy to navigate, and doesn't require excessive reliance on plugins. We are considering these options : 1.) Hydrogen by Shopify 2.) Sylius 3.) BigCommerce Open SaaS (Headless Option) 4.) OroCommerce If you have others we will consider those also. ALL options MUST be self hosted ! I am looking for a professional who can deliver a high-quality, efficient site that meets...
I'm seeking a top-tier web designer to cre...provide: - Expert-level design capabilities - Strong web development skills - Understanding of SEO principles (for geo-specific targeting) - Ability to deliver high-quality work that can be showcased in your portfolio. The gallery section will need to be flexible and adaptable, potentially incorporating features like a slideshow view, grid view, and zoom-in functionality for the artwork, though I'm open to your professional recommendations. The main focus is on design, but I also require comprehensive SEO support and Google My Business setup. Your ability to deliver 'everything that's asked of and more' is essential for this project. This is a unique opportunity to demonstrate your top-tier talent and create a...
I'm nearing the completion of a Dotnet core application designed to send prompts to an Open API and retrieve responses in HTML format for a viewer. I need some assistance with the final touches. - Main Task: - I need help primarily with the integration of the application with the Open API, specifically focusing on error handling and retry logic. - API Details: - The Open API I am working with is a RESTful API. I am looking for someone who is experienced with Dotnet core and has a strong understanding of RESTful APIs. Prior experience with error handling and retry logic in API integration is a plus. Your help will be invaluable in ensuring the final product is robust and reliable.
Please Sign Up or Login to see details.
...Amazon PAAPI, eBay API, or AliExpress product data extraction. Knowledge of automation tools like Zapier or Make (Integromat). Strong understanding of affiliate marketing workflows. Preferred Skills: Experience with Python or other scripting languages for API integrations. Knowledge of Odoo’s XML-RPC or for custom integrations. Ability to suggest and implement scalable solutions. Budget: Open to discussion based on experience and proposed solution. Timeline: ASAP If you have the skills and experience to deliver this project, please submit your proposal with: Examples of similar projects you’ve completed. Your proposed approach and tools. Estimated timeline and cost....
I am in need of a freelancer that can assist me with copying data from a protected Excel worksheet to a new, unprotected spreadsheet. Details: - I do not have the password to the protected worksheet - I can edit the worksheet, but cannot remove the protection - I need all data transferred from the protected worksheet to the new spreadsheet Ideal skills for this job would include proficiency in Excel, data entry, and an understanding of data confidentiality. As I cannot remove the protection, the freelancer will need to handle this task with discretion and professionalism.
...me identify trends in our QI project data. This will involve working with an Excel spreadsheet sourced from Redcap data. It is a NICU breast milk QI project. Data collection includes: Mother's age, mother's race, infant gestational age, insurance type, Breast pump useMilk volume at 3 different time points, volume goal of 500ml/day, Lactation clinic appointment. Scatter plot, run plot, effects of intervention: Yes/no lactation appointment attended, and does this correlate with milk volume. Key Responsibilities: - Analyze data to identify trends related to process improvements - Present findings in an accessible and clear manner Ideal Skills and Experience: - Proficiency in data analysis, particularly with Excel - Experience with QI projects - Ability to presen...
...interface and improve specific functions of the tracking algorithm. The goal is to enable researchers to efficiently train the cell tracking model and apply the model to track cells. The ideal candidate will have experience in interface design, machine learning and data visualization. Key aspects of the project include: - The primary purpose of the interface has not yet been determined and I am open to suggestions. Potential uses could include research and data analysis, infrastructure monitoring, or security and surveillance. - Consideration for the platform the interface should be compatible with is also needed. Options include a web-based application, mobile application, or desktop software. - While I have not yet specified what data needs to be tracked, I am interested in...
...Ideal Skills & Experience: Strong project management and organization skills. Experience with branding, marketing, and social media management. Proficient in financial tracking tools like Excel or Google Sheets. Familiarity with website development, online payment systems, and POS systems. Great communicator and skilled at keeping others on task. Resourceful with research and able to present clear recommendations. Scope & Budget: Scope: Ongoing, with a focus on the gym setup and other key projects in the first few months. Estimated Hours: 15–20 hours per week to start, with the potential to scale up. Budget: Open to proposals (please specify your hourly rate or fixed-price options). Preferences: Experience Level: Intermediate to Advanced. Location: Can work...
I'm looking for a unique, custom design for my lake home. The key elements of this project include: - A design style that blends seamlessly with the natural lakeside environment - An open floor plan to maximize the use of space and encourage a free flow between different areas of the home The home should feature: - Large windows that offer stunning views of the lake and allow plenty of natural light to fill the home - main floor living with second floor guest space - attached garage with both lakeside and roadside access - maximum of 40 feet wide Ideal candidates for this project should have: - Extensive experience in home design, particularly with lake homes - Experience designing for small or narrow lots that maximize living space - A keen understanding of how to incorpor...
Freelance Opportunity: AP Script Expert for Excel Sheet Automation We are looking for a skilled AP Script Expert to help automate processes in Excel sheets for our business. The ideal candidate should have expertise in creating, editing, and debugging Google Apps Scripts to streamline data handling, calculations, and report generation. Requirements: Proven experience with Google Apps Script for Excel/Google Sheets automation. Ability to create custom scripts to automate repetitive tasks, manage data, and enhance productivity. Knowledge of integrating third-party APIs (if needed) with Google Sheets. Strong problem-solving and debugging skills. Effective communication and ability to meet deadlines. Scope of Work: Analyze the current Excel workflow and id...
...Status Updates: Requests should have statuses: Pending Under Process (after Engineering Manager approval) Completed Status changes should trigger notifications. Dashboards & Reporting: Basic dashboard with the following insights: Request counts (by status, department, and priority) Average lead time (from submission to completion) Filter requests by department, category, status. Export reports to Excel/PDF. Access Control: Only authorized roles can approve/reject requests. Unauthorized users should see appropriate error messages. Custom request forms based on department/role. Technology Preferences: Web-based (accessible via PC & mobile). Simple UI with minimal complexity. Hosted online for real-time access. Suggested stack: Node.js (), MongoDB (or simple JSON storage...
I am looking for a professional contractor to link my bedroom ensuite with my house via a covered walkway. The link does not require a door into the courtyard. Key Specifications: - Type of Connection: The connection should be a covered walkway with flat roof. - Material: The walkway should be constructed predominantly with glass or in wooden joinery or open to ideas. - Style: It should adhere to a modern aesthetic. The ideal candidate will have extensive experience in designing and constructing modern, high-quality glass structures. A keen understanding of safety standards and building regulations is essential. A portfolio showcasing similar projects will be advantageous. The successful bidder will be able to deliver a structurally sound, visually appealing internal walkway th...
We are looking for a Full-time independent Node/React js freelancer with the following skill set for one of our clients. SUMMARY: - Over 6.5 years of professi...Created Typescript reusable components and services to consume REST APIs using Component-based architecture. TECHNOLOGIES: Node.js | Angular | React.js | | Java script | TypeScript DATABASE SQL | PL/SQL| MySQL | PostgreSQL | MongoDB | Amazon DynamoDB PM TOOLS: GIT | SVN | JIRA Monthly Remuneration: INR 75-80K Duration : 3 Months with very high possibility for extension. You should be open for an interview with a highly technical CTO. Please apply with your complete profile & examples of your best work. This position is ONLY for Full-time freelancers based in India. Agencies please don't waste your & o...
I'm looking for a QuickBooks Online expert to assist with matching over 201 open bills to transaction ledgers. The task involves handling multiple currencies as well. Ideal Skills and Experience: - Proficiency in QuickBooks Online - Experience with bill matching - Familiarity with multi-currency transactions - Attention to detail - Timeliness and efficiency
I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.
13 Editable supplement labels in Photoshop files, fully open with all aspects editable.
I need assistance with an Excel file. The city name is currently located in the middle columns and needs to be moved to a different column. All of the data is in one sheet. The ideal freelancer for this project should have: - Proficient Excel skills - Attention to detail - Data management experience
I'm looking for an Excel expert to help with my homework focused on analyzing scientific data. The main goal is to conduct a thorough data analysis using various statistical techniques. Key Responsibilities: - Analyze provided scientific data using Excel - Apply various statistical analysis techniques Ideal Skills: - Proficient in Excel with strong data analysis skills - Experienced in conducting statistical analysis - Familiar with scientific data sets
I need someone who can assist me with uploading songs on SoundCloud. 30 songs per account. 30 minutes of time per account. During that time you'll: - mass upload 30 songs to Soundcloud - quickly give titles for them - submit each for monetization - quickly select cover pictures (from a folder I'll provide) to go with the song - press a button to allow each of them to be "boosted" for views If you have experience with SoundCloud great, but most importantly you need to pay attention to detial. And be a bit creative Here's a preview of the job:
...Operational analysis Which areas of operations do you want to focus on? - Balanced scorecard (BSC) of the given company based on template -> Which perspectives do you want to include in the balanced scorecard? - Financial, Customer, Internal processes, Learning and development perspective Extended description of the task: Describe the vision, mission, goals and strategies of in Excel 1. Describe the financial perspective of the company selected in point 1), taking into account the following indicators: profitability (2-3 indicators, e.g. ROA, ROE), debt (1-2 indicators, e.g. total debt ratio), liquidity (1-2 indicators, e.g. current liquidity), cash conversion period (1 indicator) and risk management (1-2 indicators). 2. Describe the perspective of the customer selecte...
I'm looking for an expert Java developer who can assist me with a project focused on creating a specific web application. This involves using Visual Studio Code (VSC) and developing weekly content to complete the assignment. Key Res...implementing user authentication and database interaction features. - Excellent content creation skills. - I have attached the assignment details (its in 3 parts), sot the students should be able to provide 3 submission. - I have attached the weekly contents in excel sheet. I will need you to be good in creating weekly contnets meeting the topic lsited in the excel sheet but at the same time implementing the skills and knowledge toward completing the assignment. Please only contanct me once you go through the assignment and the excel...
...tools (we prefer After Effects). - Ability to create custom graphics and storyboard designs. - Strong skills in adding music and sound effects to elevate the video. - A creative and collaborative mindset with attention to detail. - A portfolio showcasing your best work, particularly custom animated videos. WHAT WE PROVIDE - A detailed script and professional voiceover. - Clear instructions and open communication to ensure smooth collaboration. WHAT WE ARE LOOKING FOR - Individuals or teams with a passion for creating visually stunning, engaging animated videos. - Commitment to meeting deadlines and delivering high-quality work. - A willingness to establish a long-term working relationship for future projects. THE QUALITY WE EXPECT https://www
...last-minute). Show Name: Clearly state the name of the show from which ticket price data was collected. Note whether the show is a long-running production or a special/limited run (if evident). Deliverables Excel Spreadsheet Detailed table for each theatre showing: Ticket price ranges by seating category (premium, mid-tier, budget). Seating category proportions (estimated). Dynamic pricing variations (day-of-week, seasonal, and time-based trends). Show name for each dataset. Summary sheet for ownership groups with: Aggregated ticket price ranges. Pricing trends by group and time of purchase. Evidence Folder Include screenshots showing: Ticket prices for each theatre. Dynamic pricing variations (where applicable). Seating plans (if available). Name each file clearly (e.g., ...
I'm in need of a proficient VBA CorelDRAW programmer for the 2024 version. My project involves creating a VBA script that generates QR codes within a specific template of a certain size. The script should also arrange these QR codes for printing on various printer sizes, specifically a custom size of 48x96 inches. Ideal candidate should be skilled in: - CorelDRAW and VBA - Understanding of QR code generation - Experience with custom printer size arrangements - Ability to work with specific size templates (small, medium, large)
I need a professional who can help me extract data...POS system on a daily basis. This data extraction will specifically focus on orders, with an emphasis on breaking out taxes and fees separately instead of having them lumped together as 'fees'. Key Requirements: - Data needs to be extracted daily and made available for download from a secure server. - The extracted data must be formatted in Excel. Ideal Skills and Experience: - Proficiency in data extraction from Clover POS system. - Expertise in Excel for data formatting. - Experience with secure server data handling. - Ability to meet daily deadlines. Please note, the goal is to have a detailed, clear and precise breakdown of each order, with taxes and fees itemized separately. This is essential for my accoun...
I need an Excel sheet specifically designed for conducting profit and loss analyses. The primary function of this sheet will be to facilitate financial calculations. Key Requirements: - Creation of an Excel sheet tailored for profit and loss analysis - Integration of functionalities for various financial calculations Data Entry: - All data will be entered manually, so the design should be user-friendly and intuitive for manual data input. Ideal Skills: - Proficiency in Excel - Experience in financial analysis - Ability to create user-friendly spreadsheets
Professional Template Design and Optimization
...in need of an engaging, whimsical, cartoonish-style mural featuring local historic buildings (Glen Echo Park in Glen Echo, Maryland). This mural is to be used for an invitation for our annual fundraising gala. Key Aspects: - Style: The mural should be cartoonish, not overly realistic or abstract (please see attached) - Content: It would be a map of about 7 buildings in the park, with the center open for invitation copy - Color Scheme: The mural should predominantly use cool tones, such as blues, greens, and purples. The theme is Midsummer’s Night Dream (so lots of trees, flowers and fairies throughout). Ideal Skills and Experience: - Proficiency in mural design and illustration. - Experience in creating cartoonish-style artwork. - Good understanding of local historic bui...
...contracting business. The ideal candidate will have experience in the construction and real estate industry and be proficient in using Excel for financial modeling, reporting, and analysis. Key Responsibilities: Prepare and maintain annual budgets, revenue forecasts, and expense tracking using Excel. Analyze cash flow and ensure liquidity to meet operational needs. Assist in financial decision-making by providing insights and recommendations. Monitor project budgets and ensure financial alignment with company goals. Develop financial models to forecast project costs and returns. I am looking for an experienced financial analyst who can help prepare a comprehensive Excel workbook that includes all necessary formulas for financial analysis across various aspects of...
I'm looking for a professional teste...my website before we go live. The testing should cover both the front-end and back-end, with all glitches and errors documented in an Excel sheet, categorized, and using Scrum methodology. Front-End Testing: - Usability testing: Assess the user experience and interface design. - Performance testing: Measure the responsiveness and stability. - Cross-browser testing: Ensure consistent functionality across multiple browsers, specifically Chrome, Firefox, and Safari. Back-End Testing: - Security testing: Identify any potential vulnerabilities. Ideal candidates for this project should have extensive experience in website testing, and be proficient in using Excel for documentation and Scrum for project management. Experience with secur...
I'm currently developing an iOS app that leverages the Screentime API and Family Controls. This app involves tracking usage, implementing parental controls, and setting up app restrictions. I'm seeking a seasoned Swift developer who can help troubleshoot coding issues and assist with the setup of specific code segments on a pay-per-qu...optimize performance and address any potential coding issues. Ideal Candidate: - You must be an expert in Swift, with extensive experience in Xcode and iOS development. - Prior experience working with the Screentime API and Family Controls will be a significant advantage. - You should be able to assist with bug fixing, feature implementation, and performance optimization. I'm keen to maintain an open tab and pay as queries arise. I l...
...communication skills in Hindi and English. Creative thinker who can suggest unique promotional strategies. Able to meet tight deadlines and manage multiple tasks efficiently. Duration: This will be a project-based role starting immediately and continuing until two weeks after the release of the music video. If this collaboration is successful, I plan to work with you for future projects as well. Budget: Open to negotiation based on experience and results. Please provide your rates for this project. How to Apply: Send me your portfolio or examples of successful music/entertainment PR campaigns you’ve managed. Mention any media contacts or platforms you can access. Share your proposed PR strategy briefly for a Hindi music video launch. Looking forward to working with a pas...
I am looking for a professional freelancer to help me with my project. The specifics of the project haven't been detailed yet, but I am open to discussing potential options.
I have 1 iframe code with 10 links need to select random link inside the iframe each time i open the page screenshot : php not allow use java script budget $10 only
I use CapCut to edit my videos but it’s choppy. Need some advice on how I can improve my videos. I am also open to trying another app to edit my videos on my phone. I edit on my phone and record on my phone. I find that my videos are losing focus sometimes when I record in CapCut. I uploaded a video. I’m not looking for anyone to edit videos just some guidelines to make my videos more eye catching and less choppy
I'm looking for a skilled developer who can build a colorful, interactive dashboard integrated with Shopify. This dashboard will host three assessments and a reference page. Key Features: - Survey: Users will fill out a survey sim...dashboard, allowing users to complete these assessments weekly and visualize their progress. Requirements: - Proficient in programming languages compatible with Shopify and capable of running on Android, iOS, Web browsers, PC and Mac. - Previous experience in building similar dashboards is a must. Please provide examples of your work. - Ability to create a colorful and engaging user interface. I am open to any programming language as long as it works with the specified platforms. Your expertise and creativity will be crucial in bringing this p...
I'm looking for a game developer to create a simple runner game, akin to "Talking Tom Run" or "Subway Surfers". The game should be developed for both Android and iOS platforms. Key Aspects: - Graphics: I'm open to any graphics style, be it 2D, 3D or Pixel art. - Gameplay: It's a single player game, so no multiplayer mode is required. Ideal Skills and Experience: - Proficient in cross-platform game development, particularly for Android and iOS. - Extensive knowledge of different graphics styles and ability to implement them. - Experience in creating engaging endless runner games.
I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or VERY easy because 2 /3 brands only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.
Are you an experienced graphic designer with a proven track record in creating outstanding Amazon content? We are looking for top-tier professionals who excel in designing as well as creating captivating product images and brand content, including A+ Content and Brand Stores. We are particularly interested in working with forward-thinking designers who use AI tools for bulk image generation like Midjourney, Dezgo, Adobe Firefly, and equivalents to create compelling, emotion-driven product visuals —without the need for complex photoshoots. Bonus points if you also have expertise in digitally creating product videos to enhance listings further. What we’re looking for: - Extensive experience in designing Amazon-specific content. - A deep understanding of Amazon’s ec...
PUBLISHING please PUBLISHING please PUBLISHING please If you are able to publish research papers in different areas please contact me project is for doing corrections. choosing any good journal ( mainly scopus Q1 or Q2 or Q3) I'm...scopus Q1 or Q2 or Q3) I'm seeking a professional with extensive experience in the academic publishing industry. My primary aim is to publish a paper in an academic journal, primarily to gain peer recognition. Ideal Skills: - Academic publishing experience - Strong understanding of academic journal standards - Excellent writing and editing skills - Networking within academic circles I am open to suggestions on possible fields of science and journals, but it should align with the goal of maximizing visibility and recognition within the...
We look for a professional web developer with SQL, PHP, Zend / Laminas / Wordpress and coding knowledge that can reprogram / uplift a existing and working quotes & jokes website (Mobile compatible) from Zend 1.12.2 to Laminas and from php 7.4 to php 8.3 where all current functionalities are covered (front & backend). We are also open to lift the whole project into wordpress, hence it would help to administrate the site, but this is only a option if all existing functions can be covered. The site has a database with keywords, authors, topics and pictured as well as a ranking system of the quotes. Also a improvement on current site loading speed fot most ranked quotes should be improved. SEO is also covered well now but some improvemtns might help too. We need a clear proper c...
Redesign - full logo pack with all the different files and formats, brand guidelines, media pack.
I need an expert in Excel 365 who can link two sheets for me. The first sheet should update the second in real-time. - Data Type: The data to be linked is mixed, consisting of both text and numerical data. - Version: The linking has to be done in Excel 365. Please only reach out if you're proficient in Excel and can ensure real-time data linking. Thank you.
I need a skilled Excel professional to clean up the formatting in my Excel document so that "amount" and "total" columns are formatted consistently (centered or justified to right) and ensure that existing formulas in "amount" columns calculate to amounts in "total" columns. Create formula for all "total" amounts to calculate and produce grand total at end of doc. The project involves adding new formulas ensuring that newly inserted data is added to "amount" colum that the numbers will automatically calculate and be added to the totals, similar to the setup at the beginning of the document. When in doubt please ask questions. This is a small project with a deadline of end of day to late evening Sunday, 01/26/25. Key...
