Vba refresh pivot tables datasheet refreshed jobs

...Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and Outloo...

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

...leave the record which has a value (<>NULL) in column TEL1. If none has, then leave any of those. In Microsoft Access will exist the following tables: 1. Voters (the subscribers – this will be the main database) (ID is autonumber, EL_NO is unique – no duplicates. See access file attached). 2. User (usernames and passwords, for the users to be able to login locally) 3. User_data (the data that each user will enter for each subscriber-voter). As I mentioned above in web, the user must be able to see and edit only those fields for each voter. 4. FINAL-PARTY, FINAL-_VOTE, FINAL_VOTE_CERT serve as lookup tables (see access file attached) If more tables needed to be created you can do it. Not all relationships are created in MS Access file. You have to...

I need a skilled Web Scraping specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: https://www.positiveresidual....beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're confident in your web scraping abilities, have good experience with Python, and can ensure accurate extraction of the specified player statistics from the table on the website, I'd love to hear from you.

I need a desktop application that can carefully monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new ...based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multiple tables in the DB, All joins will be provided. e. PDF will have a custom header / footer and pagination p...

I have a Node.js website where a critical bug has surfaced. Every time I log in with one ID, the session automatically switches to another ID after a page refresh. This is causing severe disruptions and needs urgent attention within 24 hours. Additionally, I would like to implement an SMS OTP system for password reset. Key Aspects: - Immediate resolution of the login bug that switches sessions. - Implementation of a secure SMS OTP system for the password reset functionality. Ideal Skills and Experience: - Proficient in Node.js and troubleshooting login related issues. - Experienced with implementing SMS OTP systems for web applications. - Quick turnaround to address the issues within the specified time frame.

...hosting) I have decent content from another of my sites to copy across to - Compress components with gzip Add Expires headers Make fewer HTTP requests Design Updates: - Changing colours: I want to refresh the colour scheme of the website to make it more vibrant and engaging - Updating fonts: The current font is outdated. I need a modern, sleek, and readable font to be implemented - Redesigning the logo: A logo redesign to reflect the updated color scheme and font Content Updates: - Updating text: The text content on the website needs to be refreshed to be more compelling, accurate and engaging - Adding new images: Incorporating new images to add visual appeal and relevance to the content - Removing outdated information: Clearing out obsolete information to keep the web...

I'm in need of a skilled 3D designer to create a virtual entertainment room that will feature a unique blend of elements. The main features of this project will include: - A 3D open room intended for entertainment purposes - 1-5 TVs and stand posters strategically placed within the room - The TVs will specifically display TV shows - The design will also incorporate corner tables and lamp The ideal candidate for this project will have a strong background in 3D design, particularly with interior spaces. You should also have a good understanding of how to create lifelike and engaging visuals. Experience in designing for entertainment spaces is a definite plus. Please include previous relevant work in your proposal.

I'm seeking a WooCommerce expert for my website's redesign, specifically the homepage. Additionally, the project includes implementing new product categories and enhancing the checkout process. Key improvements required: - Homepage Redesign: The existing presentation needs a facelift. Let's make it more modern with better user-friendly navigation. My products should be the highlight. I'd love to see your creative ideas on how to best showcase less than 50 products. - New Product Categories: Currently, I feel the product categories are inadequate. I need newer, more relevant ones added to better classify my products. - Checkout Process: Consumers love simplicity, so let's make sure that ours is as straightforward and streamlined as possible. Ideal freelancer for...

Looking for a WIX developer to add a new tab to my website and include some text and documents in it. The job is very straightforward and is expected to be completed as soon as possible. Key requirements: - Add a new tab to the existing WIX website - Populate the new tab with text and tables Please note: - This project is minimal in complexity and is expected to be completed quickly - The new tab should be seamlessly integrated into the overall design of the website - I will provide the necessary content for the text and documents - I require a WIX expert with a good eye for design and usability Ideal skills: - Proficient in WIX website builder - Experience with adding tabs and content - Strong attention to detail and design aesthetics - Availability to complete this project pro...

I'm in need of an HTML JS developer to refresh the front-end of my existing website. My web site uses pages that have components generated in JS. Many of the properties are created / set in javascript are difficult to support and change. I would like the properties moved to a CSS file where they can be set more easily. I need a developer who works hard and long hours like myself. Obviously excellent HTML/CSS/Javascript are essential for the right developer. May lead to more work doing exciting new development . .

I'm looking to extensively update the homepage of our golf course's website. Occupying a unique space in the golfing industry, we need a skilled professional who can elevate our online presence. Specifically, the tasks would involve a revamp of our site that is on jonas club management software - Revamping the visual design and page layout. This will give enhanced visual appeal and improved UX. - Integrating a video: A critical part of the new designs will be the addition of video content. Thus, proficiency in embedding and optimizing web video content is extremely crucial to this project. - Implementing an Event RSS feed: The next major addition will be an Event RSS feed. Our chosen professional should have extensive experience in working with RSS feeds to ensure seamless in...

I am seeking an accomplished web content writer to proficiently rewrite my IT Company's Website. This project specifically pertains to the "About Us," "Home," and "Solutions" pages. Ideally, the newly revitalized content will be: • Improved in readability: The refreshed content should be crystal clear, straightforward and easy to comprehend by a wide range of visitors. • Enhanced for SEO: Knowledge of keyword placement and SEO strategies is integral to this project. The goal is to increase website visibility and attract organic traffic. • Informative and Engaging: The content needs to be persuasive yet balanced, giving potential clients a thorough understanding of our services and engaging them to explore further or reach us. ...

I'm looking to create a state-of-the-art casino application in React.js. The application will include popular games like slot machines, poker tables, and blackjack tables. A crucial aspect to mimic an authentic casino experience. Design-wise, I want the application to have a sleek, modern aesthetic. It needs to look cutting-edge and attractive to users. Key functionality includes: - User Account Management: Freelancers with experience in implementing features allowing users to create, manage their accounts are desired. - Cash/Token Management: The application will need a system to manage cash or tokens for the games. It requires a safe and secure system to ensure users can easily manage their money within app. Ideal candidates for this project will have experience ...

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...

...management system. Key Features: - Data Entry Forms: These should be user-friendly and designed for efficiency. - Reporting and Analysis Tools: I need to be able to easily track productivity and analyze task-related metrics. - Data Validation Rules: The system needs to ensure the accuracy of inputted data with stringent validation rules. Structure: The database should consist of 5-10 interlinked tables for comprehensive task tracking and management. Ideal skills and experience for this job would include: - Extensive experience with Access database design, specifically around task management systems. - Strong ability to translate user needs into functional system features. - An understanding of data reporting and analysis. A successful candidate should also demonstrate close ...

Hello Özkan I’ll just make the official project for the 5 illustrations here, that we discussed earlier. To refresh, we would like 3 of the images to be of the BygMax character and 2 of Rasmus. I will attach a picture you can use as inspiration (please ignore the one with yellow background). Best regards The BygMax Team

I'm looking for a WordPress developer who can refresh the layout of my site. Key Responsibilities: - Overhauling the overall layout. one page only. Ideal Skillset: - Proficient in WordPress - Strong eye for typography and layout - Experience in UI/UX design would be a plus Your work will be vital in making my website more engaging and enhancing the user experience. I look forward to discussing this project with a professional who is passionate about website design.

I need an expert in digital marketing to help generate leads and boost sales. While the specific services required have not been decided, the focus should be on optimizing marketing efforts to target young adults aged 18 to 34. The ideal freelancer would bring a strong background in Social Media Management, SEO, and PPC Advertising. This versatility will allow us to pivot and adjust strategies as needed to ensure the highest level of success.

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

...success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that into actionable website goals. Selling Solutions: You'll present our web design packages with confidence, highlighting the value we br...

I'm looking for a skilled designer to complete a product quick start guide for the XESS ION product. A mockup created in InDesign is attached but it is only for content and to help convey the concept. High resolution product images are attached, as well as the product's datasheet for reference. It needs to be: - Sleek: It needs a fresh, modern, and professional look. - Good Layout: A new design should improve the overall structure and flow of the content. - Clear Typography: The text in the brochure is essential for understanding the content. The typography needs to be enhanced to improve the English quality and clarity. Ideal skills and experience for this project include: - Proficiency in Adobe InDesign or Illustrator - Strong design sense and the ability to create...

I'm in need of a professional who can perfectly format my 100-page Word document. The document requires: - Adjusting the page layout - Ensuring consistent and appealing font styles and sizes are used throughout - Ensuring all tables are well-formatted and visually appealing In your application, please focus on showcasing your experience in Word document formatting. I don't need any graphics or images inserted into the document, just a clean and consistent format.

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...

I am in need of a professional photographer who specializes in furniture photography. I have an apartment that I plan to host on Airbnb and require detailed, high-resolution photos of various furniture including chairs, tables, and sofas. This is a 1-2 rooms apartment, and it's essential to have photographs of every area, including the kitchen and bathroom. • Proven photography experience, especially in furniture photography • Ability to create attractive shots that capture the details • Experience in editing photos will be advantageous. • Responsibility to care for the furniture while working around it. • Proficient in effectively utilizing lighting to accentuate the aesthetics of the furniture. I want the potential Airbnb guests to see the beauty...

I'm looking for a WordPress developer to assist me in fixing some style issues on my website. Quote first one page, then we can talk about refresh of the site, so I need, on elementor 1. fix styling on testimonial 2. fix color on box 3. copy paste some call to actions

I'm searching for a skilled individual who can help me scrape data from a website. The data I'm interested in is text content and tables, specifically contact information. Ideal Skills: - Proficiency in web scraping tools - Strong experience with scraping text content and tables - Expertise in extracting specific information - Familiarity with structured data formats The contact information on the website is in a structured format. Your ability to navigate this and provide me with a clean, organized dataset will be crucial. Looking forward to collaborating with a detail-oriented and reliable professional. Attached is a sample format. The site is: Final file must contain all records for all schools on all pages

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

I need a data studio expert to create a comprehensive report for my Google Ads and meta data. The report should focus on: - Click-through rate - Conversion rate - Cost per click - Conversi...studio expert to create a comprehensive report for my Google Ads and meta data. The report should focus on: - Click-through rate - Conversion rate - Cost per click - Conversions per key word The report should cover the last 30 days. I prefer a report that represents data in tables and numbers rather than through charts and graphs. Skills required: - Proficiency in Google Data Studio - Strong understanding of Google Ads and meta data - Ability to work with large data sets and visualize information effectively in tables and numbers - Strong analytical skills to draw insights from t...

I'm seeking an Airtable expert to assist me with a number of tasks, including data entry and organization, building custom workflows, and creating advanced formulas. Ideal candidates should have: - Previous experien...building custom workflows, and creating advanced formulas. Ideal candidates should have: - Previous experience working with Airtable, including data entry and organization, workflow creation, and complex formula design - A strong understanding of how to make the most of the tool, including its integrations and automations Please note that while my exact requirements in terms of the number of tables and views in my Airtable base, as well as specific integrations I need, have not been stated, I expect the freelancer to be able to adapt to my needs and work in a...

Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system seamlessly integrates...

i need some help to refresh the jwt based on springboot 3 project

I have an existing Laravel-based ecommerce application that requires a series of modifications and additions. Key Tasks: - **New Tables & Conditions**: I'm looking to add several new tables and conditions to the application. Skills & Experience: - **Laravel Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience with ecommerce applications. The ideal candidate should be highly proficient in Laravel framework and comfortable creating new tables and conditions within the application. - **Database Management**: A solid grasp on database management is crucial to successfully add and integrate these new tables. Experience with MySQL or other relational databases is desirable.

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription

I'm in need of a skilled PHP developer to implement a table filtering and search feature on an HTML table. - The search functionality is to be based on name, facilitating instant search results as the user types. Ideal candidate should have: - Proficiency in PHP and HTML - Experience with implementing search features on HTML tables - Understanding of optimizing search functionalities for large data sets.

... |ckeckbox| MNOs mobile network operators |ckeckbox| RATs radio access technologies |ckeckbox| COs central offices |ckeckbox| Remark the term will be bolded and if appear above/previous line, in other sentence then will be written bold+italic. After selection by checbox then will save into MySQl DB. MySQL db("db_terms" named)will have some tables: URLs - table which keep the unique URLs with these columns: - pk - primary key; autogenerated - url_content ; unique URL for eg. SENTENCEs:

I am in need of a Microsoft Access specialist to create a straightforward database. The main aim of this project is the production of a simple database with a focus on data reporting. Key Points: - The database is intended for data reporting purposes. - There will be 1-5 different types of data entries (tables) in this database. - The final database should be equipped for generating various types of reports from the data it contains. - I am looking for a freelancer who can also document the database effectively. Ideal Skills and Experience: - Experience in designing and building Microsoft Access databases, specifically with a focus on reporting. - Strong knowledge of structuring databases for efficient reporting. - Ability to provide clear and concise documentation of the databas...

Company Overview: Energy Grant Access assists homeowners and tenants in the UK in accessing government-backed grants for energy-saving measures such as free boilers, heat pumps, and solar energy. Our mission is to make energy efficiency more accessible and affordable for everyone. Contest Objective: We are seeking a refreshed logo that conveys authority and trust. The logo should reflect our role as a reliable and authoritative source for energy-saving grants. Three word logo aren't easy to work with, so I expect this to be a challenge. The logo must work well in multiple mediums including web and print. I'm typically not a fan of tall logo's, but I don't want it too long either. I suspect 2 lines is the sweet spot here: Style: The logo should look official an...

I need a professional adept at advanced Excel functions to create a spreadsheet, whi...The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more opportun...

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription

I need an expert to pull data from my MySQL database, specifically from the Customers and Orders tables, and send it to a Slack channel in a unified message. The data includes text, numeric, and date entries. Key Requirements: - Integrate MySQL data with Slack: I need the freelancer to help me integrate the data entries from the specified tables with a Slack channel. - Collide Entries: The entries from the Customers and Orders tables need to be combined into a single, coherent message. - Include Specific Fields: The message should include specific fields from the MySQL tables. These fields include Customer Name, Order ID, Order Date, Customer Phone Number, Customer User ID, Product Details, and Product Quantity. Ideal Skills and Experience: - Proficient in MyS...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I am seeking a proficient Squarespace expert to refresh and enhance my website. The ideal candidate should have excellent knowledge in Squarespace content management and functionality tweaking. Key Task Areas: • Content Updates: I need additional pages and sections integrated seamlessly into my existing site. The new content should be in line with the current design for consistency. • Functionality Improvements: I am looking at improving the functionality of my website's existing features. Also, there is room for optimizing the overall website performance. Previous experience in similar projects will be preferred. I am looking forward to a proactive freelancer who can suggest creative ways to keep my website updated and efficient. Looking at a quarterly retainer...

I'm in need of a data entry professional who can handle a major project involving over 1000 pages of text data. This material is currently in a non-tabular structure, including paragraphs and sentences, rather than tables or spreadsheets. Key Responsibilities: - Accurate and efficient entry of textual data - Structuring unorganized data in a logical format Ideal Skills: - Proven experience in data entry work, preferably involving textual data - Strong understanding and ability to work with structured and unstructured data - Excellent attention to detail and commitment to error-free work - Proficient in MS Word, Excel, and data management software - Ability to interpret complex written instructions Please ensure you have sufficient time available, as this project will invol...

I need expert assistance with a specific task related to Excel. This task involves the careful extraction of data from Excel into a pivot table. The data in question is financial in nature, and more specifically, the focus is on expenses. Here is what I require: - Just the expenses data extracted from the Excel file and made available for the creation of a pivot table. - You'll need to determine the format of the data in the Expenses column. Your skills and experience: - Advanced knowledge of Microsoft Excel, especially in working with different types of data. - Proven experience in handling financial data, specifically expenses. - Ability to interpret varying formats of data on Excel. - Good problem-solving abilities, given that the specific format of the data in the...

I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription

I'm looking for a skilled professional who can convert a provided design into a PDF document using HTML format. The attached format should be replicated in the PDF. I will supply all the necessary content and images for the document. Key Requirements: - The PDF should include a header and footer as per the design. - Proper formatting and tables should be implemented. - Images and logos within the document should be accurately included. Skills and Experience: - Proficiency in HTML and experience in creating PDF documents. - Knowledge of would be advantageous. - Ability to replicate a design accurately in a PDF format. - Attention to detail to ensure all elements are correctly positioned. Budget: The fixed budget for this project is 500 INR. Please bid accordingly.