Sheet refresh vba excel 2007 jobs
I need assistance with my Microsoft Excel spreadsheets to delete duplicate rows without moving any data. The duplicates are identical rows. Ideal skills for this job include: - Proficiency in Microsoft Excel - Experience with data cleaning and management - Attention to detail to ensure all duplicates are removed accurately and efficiently.
...in need of an Excel expert to transform a spreadsheet into a comprehensive inventory system. The system should be capable of receiving and logging orders, generating invoices, and providing a form for data entry. Additionally, there should be a way to attach drawings to the relevant items. Key Requirements: - Order tracking and logging - job scheduling - Invoice generation - Form for entering details - Capability to attach files as objects in Excel The system needs to accommodate more than 200 different types of inventory items. Ideal Skills: - Advanced Excel proficiency - Experience with inventory management systems - Familiarity with invoice generation in Excel - Ability to create user-friendly data entry forms Please bid only if you have extensive ex...
I need a skilled Python programmer to help me automa...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation Budget:Rs 1050 I will give good review, if you complete my budget, Dont expect more money If you have experiece in trade automation, You...
Attached file that need updating, this sheet will be used on a monthly basis to value works completed and invoiced, the user is not very good with spreadsheets and is unable to track changes etc. What I am looking for is an easy way in which each time they open the sheet they can simply enter the percent complete in column D and columns E,F and G are updated accordingly. Need some wise logic to track rolling-over of valuations with the additions of newer percentages. Also need a provision to save the file as PDF.
I'm seeking a professional to assist with automating my Shopify store order details into a Google Sheet and sharing print files with my print company. 1. Automate Order Details: I need order item details and print files to be fed into a Google Sheet in real-time. The data should be sent without any transformation, just as raw data. 2. Sharing Print Files: The print files are stored on AWS. I need to set up an AWS EC2 instance to either add the files to a google sheet, or email the files to my print team. Ideal skills for this project: - Experience with Shopify and Google Sheets - Proficiency in AWS - Skills in setting up an EC2 instance - Ability to automate processes
i am having an excel script which is used to send whatsapp messages , some bug is there through which its not letting through properly , full message is not going NEED AN EXPERT ONLY , lets not waste anyone's time please ***urgent Language : VISUAL BASIC in EXCEL
I'm seeking a skilled data analyst who can help with comparing Excel sheets, data cleansing, and performing descriptive statistical analysis on the data. Key tasks: - Identify differences between multiple Excel sheets - Cleanse and standardize data - this includes removing duplicates, handling missing values, and standardizing formats - Conduct descriptive statistics to provide insights from the data Ideal skills and experience: - Proficient in Excel with strong attention to detail - Experienced in data cleansing and comparison - Skilled in performing and interpreting descriptive statistics - Able to deliver clear and concise reports of findings
I'm in need of a meticulous and dedicated freelancer to assist with manual data entry from scanned documents into Excel spreadsheets. Key Requirements: - Strong attention to detail and accuracy - Proficient in using Excel - Able to handle manual data entry tasks - Comfortable working with scanned documents Ideal Skills: - Data Entry - Excel proficiency - Attention to detail - Ability to work independently and meet deadlines
I'm seeking a professional with extensive experience in MS Access to assist me in creating a robust database. Ideal Skills: - Proficiency in MS Access - Experience in database design and creation - Strong understanding with data analysis, query building This is an urgent task, please bid if you are available to support immediately. Communication in English is must.
I'm looking for a skilled Excel professional to assist with merging data from various Excel sheets. Key Responsibilities: - Merging data from multiple Excel sheets into a cohesive, organized format - Ensuring specific columns or headers are accurately matched during the merging process Ideal Skills: - Advanced knowledge and experience with Excel - Strong attention to detail - Ability to follow specific instructions accurately Experience in working with amenity-based pricing data is a plus. Please provide examples of similar projects you've completed in your proposal.
I'm seeking a proficient app developer to create a comprehensive, interactive learning platform for nursing students. This app will be designed for both iOS and Android, featuring: - Interactive Course Modules: Covering crucial nursing topics like anatomy and pha...and pharmacology. - Quizzes and Practice Exams: To aid in preparation for professional certifications such as the NCLEX. - Interactive Flashcards: For quick revisions and reinforcing learning. - User Login: Ensuring personalized experience and progress tracking. The aim is to deliver a user-friendly, interactive, and education-focused app that simplifies nursing studies and empowers students to excel. If you have a knack for interactive app design and a specialization in education-oriented solutions, we would love ...
I'm looking to refresh my website to increase site traffic. The primary focus will be the homepage layout, and I will need new product/service descriptions added. This will also involve more photos being added to the gallery. Ideal Skills and Experience: - Proficient in web design and UX principles - Excellent copywriting skills, especially in product/service descriptions - Experience in SEO and increasing site traffic - Proficient in photo editing and web gallery management - Experience with website platforms (please specify which ones you have worked with)
I have a well-developed Kaizen Tracker in Excel that needs some updates. Specifically, I would like to add or update some bar charts and pie charts, rearrange some data columns related to current performance metrics, and improve the presentation of existing graphics. **Do not reply just to reply. Read the skills first** Ideal Skills: - Proficiency in Excel - both programming and user interface - Experience with data visualization - Understanding of performance tracking - Knowledge of Kaizen methodology - Looking for someone to collaborate with together Please submit your bid if you have the necessary skills and experience.
I need a proficient Data Entry Specialist. Your tasks will include: Collect leads from Source link follow Instruction Ideal Skills and Experience: - Proven experience in data entry. - Excellent attention to detail. - Proficiency in using Google sheet Rate: 100 Leads 100 INR only bid if you agree the price.
I'm seeking help with adjusting column widths in Excel to fit text without wrapping. Ideal candidates should have strong Excel skills, particularly in formatting, and be able to deliver a clear and organized spreadsheet.
I'm seeking a talented designer who can help me modernize my brand's logo and typography. The aim is to refresh the current look to be more elegant and sophisticated. Key elements to focus on: - Logo design: I need a new logo that aligns with an elegant and sophisticated aesthetic. - Typography: The typography of the brand needs to be revamped to match the new logo and overall brand feel. Ideal skills and experience: - Proven experience in logo design and typography - Strong portfolio demonstrating elegant and sophisticated designs - Ability to modernize design elements while retaining brand identity - Excellent communication skills to understand and implement feedback.
I need an Excel expert to help me lock an Excel file to restrict any one to bypass my macro password. - The task involves securing an entire workbook with a combination of a strong password and digital signatures. - Ideal candidates should have extensive experience with Excel's security features and macros. - Knowledge of creating and applying digital signatures is crucial. - The goal is to ensure that only authorized individuals can access the macro, while keeping the rest of the workbook secure. sample files attached
I'm looking for a skilled web developer to build a website that can convert various document types. Key Features: - Conversion from PDF to Word, Word to PDF, and Excel to PDF. - A user-friendly interface that allows seamless file uploads and downloads. Additional Skills: - Experience in building conversion tools is a plus. - Strong understanding of web security for user data protection. - Ability to create a responsive design that works on both desktop and mobile. Please note, this project does not require user authentication, progress tracking for conversions, or email notifications for completed conversions. I look forward to seeing your proposals.
I'm seeking a competent bookkeeper to meticulously review all my business accounts and credit cards from 2022 and 2023. This professional will itemize every transaction accurately, culminating in the creation of my Profit & Loss (P&L) statement and Balance Sheet (BS) for both my business and personal tax filings. Key Responsibilities: - Itemize all transactions following industry-standard categories for business Expenses. - Create a comprehensive P&L and BS. - Pay special attention to certain specified expenses. - Go through personal checking account statements to check for business expenses paid from the personal accounts. Ideal Skills: - Proficiency in industry-standard bookkeeping software (QuickBooks, Xero, Wave) is a plus. - Exceptional attention to detail. ...
I am using Windows 10 and Microsoft office 10 Pro. plus excel version 14.0.7268 32 bit I have one line in Excel that is occassionally repeated. When I execute the macro it should: put 20.25 in column B put 59.70 in column F put 6.95 in column G put 5.21 in column H put 4.31 in column K the numbers stay the same, but when I run the macro i created it always puts the numbers in the same row I created the macro in. I want to macro to run on the line the cursor is in. so if my cursor is at A17, and execute the macro, the numbers should go on row 17.
Need assistance checking my work, formulas, on this spreadsheet for accuracy. Mainly Row's 17 thru 20. This is a cost analysis comparison. I want to ensure the $12.50 + 1 basis point + 3 cents accurately equate to the total in row 20. These mention rows are the cost of doing business relative to the 'Card Volume' and 'Transactions' listed in Row's 5 and 6.
This is at the bottom of priority list I need this report summarized into 6 or so pages As always please recreate the charts and embed Once completed please upload backup excel files You know the drill
I'm looking for a professional who can automatically extract data from the Livescore app. The information required includes scores and match details, which should be logged in an Excel sheet. Key Project Details: - Data to be extracted: Scores and match details - Frequency of extraction: Weekly Please note, the extraction must be done automatically, not manually. I would appreciate if you could send me an example of this extraction. Ideal skills and experience for the job includes: - Proficiency in data extraction and web scraping - Experience working with mobile applications - Advanced Excel skills - Ability to provide automated solutions
I'm seeking a professional who specializes in Excel and PowerPoint to link the content of my financial dashboard across two Excel tabs to my PowerPoint slides. This will ensure any updates are synced in real-time. Ideal Candidate: - Excel and PowerPoint expert - Financially savvy - Experienced in creating professional presentations Please note: This project does not require marketing or branding expertise. The focus is strictly on financial data and presentation.
Refresh all assets with new logo and colors plus adding lancaster location to assets.
I need someone to revise my existing Google Sheets and Google Cloud Console scripts to efficiently process operational data and return results to the sheet. Key Tasks: - Review and optimize scripts in Google Sheets and Google Cloud Console. - Process operational data and return results to Google Sheets in an efficient manner. Ideal Skills: - Proficient in Google Sheets and Google Cloud Console. - Experience in scripting and data processing. - Ability to optimize scripts for efficiency.
I need assistance with my Excel line chart. I've been trying to change the maximum bounds on the format axis, but I can't seem to do it. Ideal skills for this job: - Proficiency in Excel - Experience with creating and modifying line charts - Understanding of numerical data handling in Excel
I need an Excel macro developed that can extract digital signatures from multiple PDF files and record them in an Excel file. The PDFs I am working with are digital PDFs with selectable text this files are saved in Microsoft one drive. Requirements: - The macro should capture the signer’s name and the time and date of the signature - The data should be organized in Excel with one row per document, and all signatures from that document in separate columns. Ideal Skills and Experience: - Proficient in Excel and VBA programming - Experience with PDF data extraction - Strong attention to detail to ensure accurate data capture
I need a skilled Python programmer to help me automat...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation Budget:Rs 1050 I will give good review, if you complete my budget, Dont expect for money If you have experiece in trade automation, You...
As the project name says I am looking for a Google Specialist, experienced person in advertising specifically for Cleaning companies. I need the right candidate to generate leads for my cleaning company that focuses on commercial buildings only, located in Toronto. Extra bonus if he/she knows to work on Shopify as I have to refresh and custom the website properly to acquire more leads.
I'm in need of a professional to assist with data management primarily, as well as poster design. The task involves managing and organizing mixed data (text and numbers) from paper documents into an Excel sheet. Key Responsibilities: - Data Entry: Accurately transcribe mixed data from paper documents into an Excel sheet. - Data Management: Organize and manage the data for easy access and understanding. - Poster Design: Create engaging posters based on the data. Ideal Skills: - Proficient in Excel and data management. - Strong attention to detail. - Creative design skills for poster creation. - Experience in handling mixed data is a plus. Please include relevant experience in your bid. Thank you!
Hi everyone! I have a Java-based Password Manager application that needs key enhancements to improve functionali...encryption for the master password and all stored credentials (username, email, and passwords). 2. **Master Password Unlock:** Create a feature where entering the master password unlocks a screen displaying stored credentials for all applications. 3. **App Management:** Enable adding new applications and ensure they appear dynamically in the app selection list. 4. **Optional Enhancements:** Add a bottom sheet menu for data synchronization and allow direct app connection after saving credentials. The current project files will be provided IN CHAT. I’m seeking an experienced Java developer to deliver a secure, user-friendly solution efficiently. Deadline: 25/12 B...
Budget is low! I'm seeking a skilled Excel/Google Sheets expert to assist with my trading analysis file. The sheet is pivotal for determining entry prices, evaluating trade quality, and tracking profit and loss. Key Responsibilities: - Improving and fixing complex formulas related to entry price calculations - Ensuring all calculations are accurate and reliable Ideal Qualifications: - Proficient in Excel and Google Sheets - Strong comprehension of financial calculations and trading concepts - Experience in data organization and creating visualizations Please note, while the initial focus will be on fixing and enhancing the entry price calculations, I may require additional support with data structuring and visual representation in the future. Accuracy and reli...
I'm in urgent need of a skilled professional who can help me create a comprehensive operational data sheet for an oil company. I have a very tight timeline of 24 hours for submission, so prompt and efficient work is a must. Key Tasks: - Utilize the provided data and template design to create a PDF document that closely resembles the template. - Incorporate various visual elements including charts and graphs, tables, and infographics to represent the data in a clear and engaging manner. Requirements: - Prior experience in data analysis and visualisation is crucial. - Proficiency in transforming complex data sets into easy-to-understand visual formats. - Ability to work under pressure and deliver high-quality work within a short timeframe. - Excellent attention to detail to ens...
...flight data from Excel tables. The chart will be used to track both flight schedules and aircraft positions, so it's imperative that it accurately depicts arrival and departure flights, along with their corresponding aircraft registration. Key requirements: - The horizontal axis should represent dates and times, with a red vertical line indicating the current time. - The vertical axis will show the aircraft stands. - Flights need to be depicted as horizontal bars, with the size of the bars determined by the arrival time of each flight. - Bars need to be split in case of aircraft repositioning. All of this data will be sourced from provided Excel tables which consist of flight number, time, aircraft registration, and aircraft stand. The Gantt chart must be created in...
I'm seeking an Excel expert who can add a pop-up calendar to specific cells in my spreadsheet. - Purpose: The calendar is needed for date entry for scheduling purposes. - Format: Dates will need to be entered in the DD/MM/YYYY format. Ideal candidates for this project should have a strong background in Excel, with particular experience in implementing interactive features. Please ensure you can deliver a user-friendly solution that will streamline the scheduling process.
... This means you need to check oauth every hour. Check that the refresh token or code is valid. Then read my desired data from Google. We want this application to be DEVELOP with nodejs . Familiar with express or nestjs frameworks For example I want to know how much is the remaining balance on my account number 212-343-554? To do this, I call the following service. /google-api/budget/212-343-554 At this time, you will take the data I sent and send it to Google and see the answer. We need 6 services that you need to write for us. But the most important part of the application is the oauth system for our Google account. For this, you can take help from and get the refresh and auth values. we need Services: Getting a list of accounts
Extract Ealing Landlords data from website and organize into Excel
I'm looking for an Excel specialist who can assist me in creating dashboards and performing statistical analysis. Key Requirements: - Expertise in Excel with a focus on complex functions like VLOOKUP - Proven experience in creating interactive and insightful dashboards in Excel - Strong statistical analysis skills Please note that the key metrics for the dashboard have not been determined yet, so flexibility and creativity in presenting relevant data will be appreciated.
Problem Statement: Refreshing the Tagline: Topmate's current tagline, "12 cupcakes on me if you don't like it," has been immensely popular. However, it’s time for a refresh. We need a new, Gen Z-focused tagline that resonates with their tone, humor, and values, while maintaining Topmate’s approachable and engaging personality. Make sure it aligns with topmate's positioning in colleges and young audience who are looking for guidance in various domains Push Notifications: If Topmate were to have a mobile app, we need creative and compelling push notifications tailored for its audience. These notifications should be engaging, informative, and aligned with Gen Z's conversational style. Ad Campaign for Placement Guidance: Design an ad copy tar...
I'm seeking a seasoned data analyst with substantial experience working with various programs, especially SBSS IBM, to help design surveys for data collection and analyze data collected . Key Aspects: - The primary focus will be on design surveys , analyzing o...design surveys for data collection and analyze data collected . Key Aspects: - The primary focus will be on design surveys , analyzing overall data, with a specific emphasis on measuring performance and needs assessment . - The expert will need to generate comprehensive data analysis and reports in Excel. Ideal Skills: - experience in surveys design tools like KOBO ,,,etc -Proficiency in SPSS IBM and other data analysis programs. - Strong performance measurement capabilities. - Excellent Excel skills ...
...Invoice Management: * Generate and send invoices to customers when requested. 6. Reports and Documentation: * Maintain and update the following sheets regularly: * Daily Order Sheet: Includes customer details, tracking numbers, and items shipped. * Return Sheet: Tracks all returns and their current status. * International Label Sheet: Records labels for international shipments. Requirements: * Strong organizational skills and attention to detail. * Excellent written and verbal communication skills. * Familiarity with shipping platforms and CRMs. * Proficiency in Google Sheets, Excel, and document management. * Ability to handle multiple tasks and meet deadlines. * Prior experience in e-commerce, logistics, or customer service i...
I'm looking to collaborate with a top-tier Excel Programmer and Microsoft SharePoint expert. The Scope: - I will provide all necessary Excel tables. - We will store these files in a Microsoft SharePoint folder. - You'll create an IFRAME EMBED code to include in an HTML file. - This HTML file will be hosted on our Website server. - The setup should allow display on a computer or TV browser with real-time updates. - We will input data daily into the Excel file. Key Responsibilities: - Initiate and develop the project on your own SharePoint folder. - Create the EMBED code and HTML file. - Upload the HTML file to your own Hosting server. - After ensuring everything is functioning correctly, replicate the setup on my SharePoint folder. Dashboard Requirements: ...
I'm looking for a proficient web scraper to extract product details from an industry directory. The required information includes product names and descriptions. Ideal Skills: - Proficiency in web scraping tools and software - Experience in data extraction from industry directories - Familiarity with Excel for data organization Please ensure the final output is well-organized in an Excel spreadsheet for easy understanding and analysis.
...required) statement of Debtors Receivable, Creditors Payables plus any control accounts 7. Monthly Reconciliation of all Bank accounts 8. Calculation at year end of provisioning of Gratuity and Leave Salary for the staff 9. Periodical closure of books for preparation of Trial Balance, Balance Sheet and Profit/Loss account 10. Submission of Monthly and Yearly Accounting Reports 11. These monthly MIS Profit Reports would provide business in-sight, analytical report and recommendations - in easy-to-understand excel/pdf format, which can be customized as per requirements 12. After submission of the accounting records, on a monthly basis at mutually agreed time and date, these reports can be discussed in online or in physical meeting 13. Complementary Tax advisory meeting. At a...
Problem Statement: Refreshing the Tagline: Topmate's current tagline, "12 cupcakes on me if you don't like it," has been immensely popular. However, it’s time for a refresh. We need a new, Gen Z-focused tagline that resonates with their tone, humor, and values, while maintaining Topmate’s approachable and engaging personality. Make sure it aligns with topmate's positioning in colleges and young audience who are looking for guidance in various domains Push Notifications: If Topmate were to have a mobile app, we need creative and compelling push notifications tailored for its audience. These notifications should be engaging, informative, and aligned with Gen Z's conversational style. Ad Campaign for Placement Guidance: Design an ad copy tar...
I'm looking for a Qlik Sense expert who can create three comprehensive dashboards for our university's higher management. These dashboards will present key information including our admission rates, total number of students per year and semester, financial income, and graduation rates. Key Requirements: - Data Source: The dashboards need to pull data from CSV/Excel files. - User Access Control: The dashboards need to have different levels of access for different users. - Admission Rate Metrics: The dashboards should display the overall admission rate and the admission rate by department. Ideal Skills: - Extensive experience with Qlik Sense. - Proficiency in data handling and visualization. - Knowledge of designing user access controlled dashboards. - Ability to create de...
...I'm seeking an expert in Microsoft 365 with strong skills in Excel, PowerPoint, and VBA programming. My goal is to create a PowerPoint macro that automatically generates a slide for each participant of a course, inserting their name and course date from an Excel file. Project Details: - Software: The project will be conducted using Microsoft 365. - Data Source: The macro will pull data from an Excel file, specifically participant names and course dates. - Template: I have a specific PowerPoint template for the slides; the freelancer will be provided with this template. Key Requirements: - Advanced knowledge of Microsoft 365, particularly PowerPoint and Excel. - Proficiency in creating and implementing macros. - Experience with VBA progra...
