Importing excel sheet access database vbaemplois
I'm looking to translate an excel spreadsheet to an easy-to-use Google Sheet. - Conversion: Translate the full content of the Excel spreadsheet to Google Sheet without compromising the quality or missing any data points. - Functionalities: Ensure all formulas used in the current Excel sheet work perfectly on the Google Sheet. - Logo Placement: Importantly, I want my logo positioned in the top-left corner of the Google Sheet's header, maintaining its clarity and visual dominance in the design. The ideal freelancer for this task would be someone with extensive experience in Excel, Google Sheets, and graphic placement. Practical knowledge of maintaining spreadsheet functionalities during a transition is critically essentia...
I require an experienced data entry freelancer with a strong proficiency in Excel and Word. The project entails translating text data from Word documents into Excel. The data is organized in tabular form in the word documents. Key Skill requirements: - Advanced level competency in Excel and Word - Attention to detail to ensure no data discrepancy - Speed and accuracy Experience in similar projects would be an added advantage. This job would suit someone who excels at meticulous organization with a knack for data structure. I await your bids.
Please note the following before bidding: GoDaddy host our sites. We will provide admin access to that site during the project. The theme is already purchased. It is developing the layout and providing a number of templates that we can use across the site. We will add all pictures and content. We just want an easy to use layout. In your submission state that you understand the brief. If you need more information to quote, then say that upfront. It seems on this site, people put in a low-ball quote and once a discussion starts then there is a massive increase in price. Not the way we work. General brief is: We are seeking a person to create a website based on the "Education Blocks" theme using the provided site map: We will add all content⸻ Website Name: TBA Theme: Ed...
...SQL and developing the necessary functionalities on your Wix Application: **Azure SQL Integration and Database Setup:** - Integrate the system with Azure SQL. - Create databases for **Customer Information**, **Customer Sizing**, **Certification Information**, **Purchase Information**, **Courses**, and **Certification Dates**. - Define data structure and schema based on the provided Excel sheets. - Develop data import and validation processes. - Implement security measures and conduct regular audits. **Wix Application Development:** - Develop forms and interfaces for adding and modifying student information. - Implement automatic linking of website members to the Customer Information database based on email and birthdate. - Create courses dates and times - Create f...
I am in need of a comprehensive research paper focusing on the New York Police Department's (NYPD) Stop-and-Frisk policy. The objective is to evaluate its fairness, transparency, and potential implications on community trust. there will be 10 datasets each containing 18000 rows of data per dataset The following objectives should be met for this research paper. You should have identified and access to the dataset you plan on using (if any) for your research paper. You should have the introduction, literature review completed. You should have research questions, motivation and/or hypothesis and methodology identified/completed. You should have your exploratory data analytics completed You should have your implementation/results completed You should have your conclusions and fu...
I am in need of detailed-oriented individuals who can manually extract text and images from specified sections of a website. This data should be compiled into an Excel file and extracted every 4 hours. The work is fairly straightforward: * Take a screenshot of the specific pages. * Manually types the information from specific parts of a webpage * Save text into an Excel file * Regular updates - data should be extracted every 4 hours and sent to me everyday The ideal candidate should be meticulous and reliable, with excellent time management skills. Familiarity with Excel and basic data extraction methods is also required.
I have code for login trading accound and fetch token data. I need to update code to my system. you can create new code for my requirement at same cost.I need to collect live data from the web and candle stick with different time frame.I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Stock Broker account: If Buy signal find it will automaticlly place Buy order,etc., Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply
I am in need of a comprehensive research paper focusing on the New York Police Department's (NYPD) Stop-and-Frisk policy. The objective is to evaluate its fairness, transparency, and potential implications on community trust. there will be 10 datasets each containing 18000 rows of data The following objectives should be met for this research paper. You should have identified and access to the dataset you plan on using (if any) for your research paper. You should have the introduction, literature review completed. You should have research questions, motivation and/or hypothesis and methodology identified/completed. You should have your exploratory data analytics completed You should have your implementation/results completed You should have your conclusions and future researc...
I'm seeking someone in Mexico who can assist in sending our catalogues to a local expo. I will send name cards and small sheet of samples to you , you help me to send on the expo and pick up customer name cards , take a photos to show their booth and name cards , the purchaseman name card only
I am seeking someone to help me check and complete a trial balance statement (in Excel) so that it balances (or ensure there are no main missing items on it). There are only a few items that are unresolved. I can provide data of income and expense transaction (as needed) in summarized form, including Income Statement, detail of tax filing, bank statement etc. Data will be anonymized (i.e. staff, customer and supplier names concealed) for privacy reasons.
I'm in need of skilled mechanical engineers with experience in the electric vehicle (EV) space for a unique project. We are looking for vehicle development engineers with expertise in CAD design/development skills (Fusion 360/Inventor/SolidWorks), with DFM/DFA/GD&T and manufacturing experience for CNC machining, molding, casting, sheet metal and forging. The Project: - I'm working on a new, innovative vehicle. While I'm not disclosing a specific audience at the moment, the vehicle is similar in scope to an electric bike or electric scooter. Your passion and experience with the EV industry and your ability to think outside the box will be highly valued. I look forward to seeing your proposals.
I am looking for a qualified freelancer who can assist in setting up, managing, and troubleshooting my Microsoft 365 deployment. Specifically, I require support in: - Configuration of Microsoft 365 - Setup less than 10 users, including access control - Ongoing troubleshooting and support post-deployment - Syncing of emails and calendars - Configuring organizational level sharing and security policies. Freelancer should have experience with Microsoft 365 and be familiar with customizing access controls based on specific job roles. Knowledge of email and calendar syncing (gmail to outlook. Outlook to teams, etc, as well as file sharing within the platform is also desirable.
I'm seeking a thorough and accurate compilation of flooring distributor's or contractors, home builders, or property management companies/apartment complexes, within my area, both at the residential and commercial levels. The information should be geared towards the following: - Contractor Contact Details: Your bid should reflect your capacity to provide me with a comprehensive list of names, phone numbers, email addresses, and physical addresses for these flooring contractors. Having familiarity with data entry, web scraping, and the construction industry would be a plus for this task. My end goal is to have a dependable directory I can refer to as needed. It's essential the information gathered is accurate and up-to-date.
Hello, I have a xlsx file with 2 sheets (sheet 1: data; sheet 2: pivot table), I need a vba macro that do this: - Delete data from sheet 1; - Import a txt file (the user can select it) in sheet 1; - Update the pivot table without changing formatting. And will share you more details in via chat box. Thanks
Hi Shakil, there are a few small tasks to fix some stuff on the MKT website A) SHOP PAGE 1) Change the frame around the product boxes 2) Change the fonts in the product boxes The Shop is a Woo Commerce Shop. The access to the FTP Server will be provided. A PSD with further instructions regarding color, frame thickness and fonts will be provided. B) HOME PAGE The task is to block the 2 floating orange buttons on the right on mobile screens, as they cover the content on mobile.
As an employer looking to test the excel proficiency of job applicants, I am in need of a freelancer to create an advanced level excel test. This test should accurately assess applicants' skills in the areas of formulas and functions, data analysis and manipulation and formatting and visualization. Skills and Experience: - Profound experience with Excel including sound knowledge of advanced formulas and functions. - Prior experience in creating excel tests or educational materials. - Strong understanding of data analysis/manipulation techniques. - Competency in formatting data and visualization features in Excel. The ideal person for this job has experience in creating similar proficiency tests and has an 'advanced' level understanding ...
I'm in need of a reliable freelancer to help me automate the daily backup of my PHP table data to an Excel sheet. The primary purpose of this task is to ensure that all the data on my PHP table is safely stored in an Excel sheet for backup purposes. The data includes important records that I can't afford to lose. The ideal freelancer for this project would have: - Proficiency in PHP and Excel VBA for automation - Experience in data storage and backup systems - Ability to ensure data integrity during the transfer - Excellent attention to detail to ensure all data is backed up correctly - Availability to set up and maintain a daily process If you have the skills and experience to complete this project efficiently and accurately, please r...
...the condominium premises in real-time. 2. Facial Recognition: It has to recognize residents from guests, aiding in the identification of unauthorized individuals. 3. Activity Monitoring: The system should be smart enough to monitor activities within the common and specific areas round-the-clock. This project will be implemented from scratch; we don't have any existing surveillance cameras or access control systems at the moment. Ideal candidates should have a proven track record with Computer Vision/AI technologies, such as TensorFlow or OpenCV, and experience with hardware integration. Prior experience in security surveillance software development will be a plus. A developer with expertise in computer vision, artificial intelligence, and deep learning is needed to cre...
...(iRedMail). In trying to configure it, I mistakenly reinstalled mysql. As a result, I've lost the databases that were previously stored in /var/lib/mysql. - I have full access to the VPS and can login via the command line. - The MySQL service is currently running on the VPS, but it's empty as I need to recover old databases. - I have specific information about the databases and tables that were deleted. I'm in urgent need of a skilled professional who can help me recover the lost databases. The ideal candidate should possess: - Profound experience in database recovery, particularly on Ubuntu VPS. - In-depth understanding of MySQL database structures. - Ability to work efficiently through command line interfaces. - Strong problem-solving skills and ...
Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 7 Hours not more then this, i had the excel to work on just make this on new sheet
I need a competent professional to smoothly facilitate the migration of my MSSQL 2019 database to a new server. Additionally, the ownership of SQL Management Studio must be changed effectively. Key job responsibilities: - Safe and efficient migration of the MSSQL 2019 database to a new server - Successfully transfer ownership of SQL Management Studio Ideal Skills and Experience: - Proven expertise in MSSQL 2019 and prior versions - Proficient in handling SQL Management Studio - Experience in successful database migration projects - Detail-oriented in project proposals Please note that only freelancers providing detailed project proposals will be considered. Your proposal should demonstrate your understanding of the project requirements as well as how you intend to ...
...POS system. **Key Features:** 1. **QR Scanning:** Customers can access our digital menu by scanning a QR code at the restaurant. 2. **POS System Integration:** Orders can be created directly from the counter system. **POS System Requirements:** - **Real-time Inventory Management:** Instant monitoring of stock levels for efficient operations. - **Customer Relationship Management:** Understanding and meeting customer preferences and needs. - **Sales Reporting and Analytics:** Informed decision-making and strategic planning. **Payment Options:** The system should support both cash and credit/debit card payments for customer convenience. **Additional Features:** - **Convert Traditional Menu to Digital:** QR code enables easy access to the digital menu. - **Complete POS Sys...
I'm looking for a talented Bubble developer to create a WebApp for the member's area of my online course. Key Features: - User Registration and Login: Secure system for user authentication. - Course Content Management: Ensuring smooth and organized access to course materials. - Progress Tracking: Members should be able to view their progress and completed tasks. - Support Page: A space where they can ask questions and get help. - Tools: Incorporation of simple tools for calculations like body fat percentage index. Design Aesthetic: - Minimalist: A clean, simple and organized design to ensure focus on content and functionality. Skills and Experience: - Proficiency in Bubble development. - Previous experience with building member's areas and online courses. - Design...
I am in need of a freelancer who can create paginated Access reports. The job involves: - Using data from MS-Access to use in the report. - Converting the extracted data into paginated reports. - Very good knowledge of SQL. The perfect candidate will be proficient in manipulating SQL language and creating Access reports, with a keen eye for detail and a some understanding of sales data. Background in SQL language and Microsoft Access report is advantageous. Attached is a sample of the report I need the candidate to perform, but in much better format and with the correct information extracted for each column.
...strategy and blog writing with a strong grasp of IoT and CCTV access control industry. Here's what you should be able to help me with: - Social Media Platforms: I am looking to focus on Facebook, Twitter, Instagram, and LinkedIn. You should have proven experience in managing and growing accounts on these platforms. - Social Media Marketing Goals: I aim to increase brand awareness, drive website traffic, and generate leads and sales through these platforms. You should be able to develop a comprehensive strategy to achieve these goals. - Content Creation: I am looking for a mix of engaging text-based posts and visually appealing graphics and images. Your content should resonate with the target audience in the IoT and CCTV access control industry. Ideal Skills and Expe...
I'm looking for an experienced software developer to create a comprehensive electronic health record system that is compatible with both Windows and Mac operating systems. Key functionalities: - Patient Record Management: The software should allow for the secure and efficient management of patient records, ensuring easy access and update of medical information. - Appointment Scheduling: Users should be able to schedule appointments, view upcoming appointments, and receive reminders. - Billing and Invoicing: The system should support billing and invoicing processes, facilitating the financial aspects of patient care. While I'm unsure about specific integration needs at the moment, the ideal candidate should be open and capable of discussing potential integration w...
Looking for a skilled freelancer to efficiently transfer 500 questions from Microsoft Word to an Excel spreadsheet. This task requires precision and attention to detail. If you have experience with data entry and are proficient in both Word and Excel, we'd like to hear from you. This is a straightforward project with clear instructions, offering flexibility and a competitive rate. Join our team and help us streamline our data management process.
I'm in need of a freelancer who has a vast list of verified dentist emails. This list should include the individual's name, company name, city, email address, and phone number. My main goal for this project is t...company name, city, email address, and phone number. My main goal for this project is to utilize this list for a national level marketing outreach. Ideal Skills and Experience: - Proven experience in Email List Building, particularly in the dental industry. - Strong attention to detail to ensure the validity and quality of the email list. - Ability to work efficiently and deliver the list in an Excel spreadsheet format. Please only apply if you have a pre-existing, substantial list of dentist emails. The quality of the contacts is crucial for the success of my...
I need an experienced web developer who will build a custom website tailored to my specifica...main focus of my site. Site Features: • About Us section - This will provide visitors with a comprehensive view of what my business is about. • Team Bios - I want a section where information about the people behind the business can be displayed. • FAQ - A section that will detail answers to frequently asked questions will be required. Ideal Skills and Experience: For this project, you should excel in custom-built web development, have an understanding of infopages design, and be able to build robust FAQ and Bio sections. Your portfolio should show your experience in these areas. Experience with user interface design is a plus as well since the website has to be user-frie...
I'm seeking a grant writer to help expand our children's performing arts program. The main objective is to secure funding from private foundations, in order to extend the reach of our program to schools lacking arts pr...be required to: - Research and identify potential private foundation grant opportunities. - Write compelling grant proposals tailored to the expansion of our program to schools lacking arts programs. - Work closely with me to ensure the proposals align with the vision and goals of our program. - Demonstrate eagerness to expand the reach of our program and a commitment to providing children with access to the arts. I'm looking for a dedicated professional with the skills and experience to help us reach a wider audience and enhance the lives of more c...
I'm currently working with two Excel sheets for inventory data. I need help with applying VLOOKUP functions to these sheets. I need the correct formula to lookup the Sheet 1 Column A data, in Sheet 2 Column B, and apply Sheet 2 Column B data in Sheet 1 Column B - please see attached. Key Requirements: - Understand and implement VLOOKUP formula to connect data between the two sheets. - Ensure the VLOOKUP function is working correctly and efficiently. Ideal Skills and Experience: - Proficiency in Excel functions, particularly VLOOKUP. - Prior experience working with Inventory data is a plus. - Attention to detail and accuracy in data manipulation. Please reach out if you're confident in your Excel skills and can assist with t...
I need assistance with converting various Excel, Word, and PDF documents, making up a total of 32 pages, into a comprehensive and printable directory. Here's what would make you a great fit for this: - Proficiency in data entry and conversion between formats. - Strong skills in Excel, Word, and creating PDFs. - Experience in building and formatting directories. - A track record of delivering high-quality, print-ready documents. Key Tasks Include: - Collation and organization of information from different files. - Conversion of these files into a uniform, printable PDF. - Quality checks to ensure formatting remains consistent and ready for print. Please bear in mind, the final directory is not intended to be searchable. It should be built and formatted for printing wh...
I need an expert in data management and social media analytics to help create a database for my Instagram followers. Key tasks will include: 1. Organizing the database by follower engagement level. 2. Including both the username and follower count of each Instagram follower in the database. 3. Providing monthly updates for the database. The ideal freelancer for this project should have extensive experience with data organization and social media analytics. Mighty beneficial if you have prior experience creating or managing similar databases. Comfort with Instagram's platform and an understanding of how to categorize user engagement will be crucial to this project.
I'm looking to hire an experienced WordPress developer to restore both my WordPress database and website files from a backup I have. The site was running on a version of WordPress earlier than 4.x. The restoration will take place on the same domain. Skills & Experience Required: • Proficiency in WordPress database and website restoration. • Experience with restoring older versions of WordPress, specifically versions prior to WordPress 4.x. • Understanding of domain configurations and restoration processes. Please provide evidence of similar projects you have completed in the past. This project requires an expert touch so as not to lose invaluable data during the restoration process. Therefore, knowledge of data handling and previous experience ar...
...over and over again.) 2. User gets sent to our site, where they insert their phone number to get a code. 3. This code needs to be one-time use, only redeemable once. 4. The code grants them access to "store profile" (of the store that they scanned the code from). 5. From the store profile, they can choose to unlock a discount from a list of stores that have partnered with the store who's profile they're on. For example: I go to Walmart, I scan a code. The code takes me to my consulting website. I enter my phone number, and receive a text code. This text code (which is one-time use) will grant me access to Walmart's store profile on my website. Once I'm in there, say Walmart has partnered with McDonalds, Honda, and Winners, I choose one of the...
I require a professional with a meticulous eye for detail and proficiency in spreadsheet tools, such as Excel, to handle my data entry project. The data, which needs to be manually inputted, will be derived from scanned documents. Your role will primarily involve re-typing the content into neat and orderly spreadsheets. Ideal skills that you must possess include: - Speed and accuracy in typing - Proficiency in data entry and management - A keen eye for spotting errors or inconsistencies - Familiarity with spreadsheet tools like Excel - Ability to handle confidential information if it arises Your previous experience with similar projects will be a definite advantage. Kindly ensure you include it in your proposal. Please also highlight your availability and estimated timefr...
i want some one who has a classifieds database or website with below data 1 - categories and subcategories 2- filter and sub filters For example property - house, land, apartment phone - 1) android 2) ios filters under them 1)ram 2)rom 3)colour under that filters ram 4 to 16 gb ,rom 4 to 16 gb and colour black,white ,red like that below example with different categories property ,cars, bikes, furniture , jobs etc ................. need data in excel
...crafting a mobile cryptocurrency wallet specifically for Android. The potential freelancer should ensure the wallet includes: - Real-time tracking of cryptocurrency value to keep users updated about the market trend. - Basic transactional capabilities, allowing the sending and receiving of cryptocurrencies. - Advanced security features are critical. This includes two-factor authentication, biometric access, to reinforce the wallet's security. - Lastly, the wallet should be capable of funding projects (This means that users can seek for funding in crypto using the app aswell). The ideal candidate should have experience developing Android applications, with a specific focus on financial or cryptocurrency-based systems, displaying a strong understanding of blockchain techn...
I need assistance with Excel, specifically with its worksheet formatting feature. My main goal is to create tables and charts to visually represent my financial data. The perfect freelancer for this job should have extensive experience in data visualization, especially when it comes to: Creating accurate formulas displaying in a clean manner
As an experienced graphics designer, I need your help to create PNG and Adobe Photoshop artworks s...experienced graphics designer, I need your help to create PNG and Adobe Photoshop artworks strictly for print designs. These designs must align with the specifics in the artwork samples that will be provided. Experience with color matching is a prerequisite since the color scheme should strictly adhere to the provided samples. The sizes and dimensions for each design will be given in an attached excel file, and I require the artworks to follow these exact measurements. Bullet points: - Print design expertise - Excellent color matching skill - Ability to adhere to specific dimension requirements in artworks - Proficient in PNG and Adobe Photoshop Bid you price for all 6 designs...
I'm seeking a freelancer with outstanding Excel skills to compile a comprehensive list for personal contacts. The required data for each contact includes: - Name - Address - Phone number It's essential to meticulously organize and enter the required data into the spreadsheet. Precise attention to detail is crucial to ensure no errors are made when adding the details. While there isn't a specific order for the data I will provide you with, I expect clear and uncluttered presentation will be kept as a consistent standard. The ideal freelancer should have: - Proven experience with data entry - Keen attention to detail - Excellent organizational skills - Proficient Skills in Microsoft Excel. If this sounds like you, I encourage you to bid. Let's ge...
I'm looking for a skilled freelancer who can develop a comprehensive Excel dashboard for tracking financial performance. This will primarily involve creating charts and visual representations of the following data: - Sales Data - Expenses Data - Profit Data The main purpose of this dashboard is to facilitate easy tracking and visualization of our financial performance. Ideally, successful freelancers will have: - Relevant experience creating Excel dashboards for financial tracking - A deep understanding of accounting principles
Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet
As a client, I'm looking for a Flask expert who can seamlessly integrate an existing Firestore database into my project. This requires a deep understanding of Flask, Firestore, and how to make them work together efficiently.
Looking for someone who already has the template and can upload it to shopify and make some changes. remove some sections and change text font and button colours.
I'm in need of a developer to help me transform the tables on my web platform into a downloadable Excel sheet. This needs to be done in a way that the Excel sheet maintains the same order and all data fields as seen on our website. Job requirements: - Extract all data fields from our websites data tables - Develop a downloadable Excel sheet functionality for each table - Ensure the data maintains the same order as on the website - Use PHP and Javascript languages Key details: - Users are expected to download updates on-demand - The Excel sheet should be styled to match the website's design I'm looking for a developer who is proficient in both PHP and Javascript and has prior experience working with similar data tra...
I'm seeking a skilled financial analyst to create a comprehensive financial model for my real estate venture. This model will serve as a business plan for the company and will primarily focus on attracting potential partners. Key deliverables: - A detailed financial model for two Business Units (BU) - Consolidated 3 Financial Statements (Income Statement, Balance Sheet, Cash Flow Statement) for 10 years of operation - Company valuation based on the financial projections Key Assumptions: - Revenue growth rate - Operating expenses - Capital expenditures - Real Estate investments - Real Estate consulting services The ideal candidate should have a background in corporate finance and experience with creating financial models for real estate ventures. A deep understanding of the ...
...between the website and the blockchain network. 2) Secure the data exchange during transmission and reception. Unique Identification Generation: 1) Generate unique codes for each unit of energy produced. 2) Associate these codes with specific solar inverters and corresponding records. Authentication and Security: 1) Ensure data security during transfer and storage processes. 2) Restrict system access to authorized users only. Real-Time Monitoring and Verification: 1) Enable users to verify the authenticity of the energy certificates they wish to purchase. 2) Establish a transparent system for users to track the source of the energy. Wallet Integration: 1) Develop a secure wallet system within the carbon exchange website. 2) Enable users to securely store and manage their ...
Looking for a WordPress Developer to build an affiliate landing page system. - Domain Name (We already have a domain name) ...landing pages and able to view some statistics such as how many affiliates, visitors and leads. - Affiliate dashboard to view their data and results such as how many visitors and leads. - Admin, Affiliate and Leads will auto receive an email auto-responder after filling up the form and submit (In Elementor Form, we know that there's an Email 1 and Email 2) - Every data to auto appear in Google sheet (is it possible) - Purely use Elementor and Elementor Pro if possible - Desktop, Tablet & Mobile friendly The timeline for this project is within a month. I am looking forward to collaborating with a professional who can deliver a reliable system wit...