Excel refresh data moves columns jobs

...who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application. Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solvi...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

...filterable table into my personal blog, which will continuously pull data from a Google Sheets document. The key points of the project are: - **Table Embedding:** The primary task is to take the data from my Google Sheets and convert it into a visually engaging table on my blog. This table should be easily filterable and sortable based on different columns. - **Automatic Updates:** The data in the Google Sheets will be changing daily. I need to ensure that the table on my blog automatically updates whenever the Google Sheets data changes. Ideal candidates should have experience with: - Data handling and visualization - Google Sheets API - Web development (specifically embedding tables) - Automation and real-time data updates on websi...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work...

I need an experienced WordPress developer to work on specific page updates with Elementor and ensure they're completed by Monday morning. Key Requirements: - Implement design changes: The primary goal is to refresh the brand image, ensuring it's consistent with our current branding. - Efficient and quick: This is an urgent task, I need someone who can start today and complete it by Monday morning. Ideal Skills and Experience: - Proficient in WordPress: You should be well-versed in WordPress, particularly in working with Elementor. - Strong design sense: Experience with design and branding is crucial to ensure the updated pages align with our brand image. - Time management: The ability to work under tight deadlines and deliver high-quality results promptly is extremely im...

I'm seeking a talented graphic designer to refresh our website design for on mobile and desktop platforms . Must make the website quicker and incredibly user friendly. Key Requirements: - I need the website to have a clean, professional look that accurately reflects the informative content. - It should be user-friendly and intuitive to navigate, focusing on providing a seamless user experience. - The design should incorporate a consistent color scheme and typography that aligns with the overall branding. Ideal Skill Sets: - Strong understanding of user experience and user interface design. - Proficiency in graphic design software and tools. - Prior experience in designing and developing informational websites. - Excellent communication skills to ensure that the

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I have an excel file, need add product categorie on a column - budget 100€

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analy...

Hello, I need complet the Amazon categories catalogue excel in french

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

...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...

...need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheet...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. P...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accu...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...who is proficient in Autodesk Revit. My project requires: The Conversion of 3D laser scans with BLK360 into high quality, detailed Revit models. The objects is the survey of information of a structure of 335m2 in plan made up of two levels, the first level consists of a structure of 6 columns that are part of a system of frames resistant to moments, on an articulated base. On the second level there are two structures to support the air coolers, in each one there are 4 fans and they are made up of 15 columns working in a system of gantries with concentric braces. The information that the survey must contain is: Geometry, profiles, connections, gas pipes, equipment or elements that may present interference in case of reinforcement. The information must be presented in a 3...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...

I am currently using R, specifically the ppcor package, to conduct partial correlations on a sizable dataset. Unfortunately, the process is slow and fails to address all columns efficiently. I'm seeking assistance to: - Improve the computation speed - Enhance the handling of columns within my dataset The ideal freelancer for this task should be proficient in R programming, with specific experience in working with the ppcor package or similar tools for statistical analysis. A background in optimizing code for large datasets would be highly beneficial.

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

I'm in need of a skilled cross-platform app developer to create an application for my car cover company. This smart home app will control WIFI lights and fans specifically. Key functionalities include: - Ability to control lights ...development team with a strong background in cross-platform app development, specifically working on smart home apps. Awareness of IoT would be beneficial, given the smart home focus. Considering user experience, the app should be intuitive, easy to use, and visually appealing, therefore, UX/UI design skills are critical. This project is an interesting opportunity to work on an application that moves beyond standard functionalities and delves into home automation. If you've got the skills and the interest in smart home technologies, I'...

...thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyword research tools and SEO optimization techniques specific to YouTube. - Proficiency in utilizing analytics tools to drive decisions and enhance content performance. - Strong creative skills for developing eye-catching thumbnails and titles. - Passionate about the YouTube platform and staying up-to-date with the latest trends and algorithm changes. If you're ready to join a results-driven team and help businesses across various industries excel on YouTube, we'd love to hear from you. A perfe...

create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tas...Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concep...

create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tas...Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concep...

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tab...Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and share th...

...skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing the products that he wants to sell. The excel file has 5 columns: 1st columns is for Brand 2nd column is for Model 3rd column is for Color 4th column is for Price 5th colums is for Quantity in Stock We want to realize a simple php page with a form to send an email with the chosen products. We need that someone just fill the database wkth the data we have in excel file (about 350 lines) To access the page we need a login page. We need 2 levels: 1 level: administrator 2nd level: agents One administrator is suffic...

We need the following combination of online database and data entry interface from users + a local MS access file. Online Database and web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Admi...

...specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a 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

I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong atte...

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. Key Aspects: - Immediate resolution of the login bug that switches sessions. Ideal Skills and Experience: - Proficient in Node.js and troubleshooting login related issues. - Quick turnaround to address the issues within the specified time frame.

...relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need acc...

...across editing the design, content, and functionality aspects. (I just bought this from Astra Pro with Spectra, essential, Optimizer and YOAST - along with the Godaddy WordPress 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

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking for a 5-star review.

...identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source material, with the primary emphasis on the collation/assembly into the required format. An example of the required spreadsheet format is available – however it is simply 3 columns...

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The idea...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

...maps. The goal is to clearly illustrate the evacuation routes within the building's layout. Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel. - Experience working on evacuation plans or similar projects is an advantage. - Knowledge of color-coding and its application within floor plans to ensure the clarity of the evacuation routes. The ...