Increment column macro jobs

I would like a CSV / excel file of a list of up to 500 Small Retail Stores on the East Coast of the US (non-Global brands such as Zinnia or Shoes N' More) and their emails. Rather than a generic company email, it would be ideal to have an email of a contact at the company, for example, the CEO or Head of Marketing. Ideally a three column sheet with name of company, name of contact (ex: Head of Marketing), and company contact email.

Hello, I hope you are well. My name is Raquel Mojica, I am an expert in Power BI (file reconstruction, DAX formula changes, chart modification, KPI's and dashboards development, database restructuring), data validation and analysis, massive data management and Excel Advanced (Pivot, Advanced Formulas, graphics, commands, binaries, Excel macro programming, VBA programming). You can validate my experience in this link: https://www.freelancer.com/u/araquelus I can help you with your Power BI project. Also, I can help you with my business experience creating KPIs that can help you make long-term strategic decisions. I have knowledge and experience in: - Databases with more than 500k rows and more than 100 columns - Run DAX queries and functions in Power BI - User access security ...

...proceed. VBA might be sufficient but I want to work with R. I am going to give you a little more information. From the example file sent. I want to match the keywords from with the Keywords in the column 44 Keywords. So for example taking the following example (row 30) [Column 4 Title] A highly selective and sensitive disposable carbon composite PVC-based membrane for determination of lead ion in environmental samples by [Column 2 Author] A.; Mirahmadi Abbaspour, E.; Khalafi-Nejad, A.; Babamohammadi, S We can see in [Column 44 Keywords Copy1] (which is the a copy of the column 29 Keywords this was for my information not yours) the following Key words are listed: *Carbon; Environmental Pollutants/*analysis; *Ion-Selective Electrodes; Lead/*analysis; Ma...

...help me categorize a list of 2000 URLs of AI Tool providers into various categories the url would be a match for. There would be a list of about 60-70 categories. You will need to check off all relevant categories for each url. Link to the master excel file is: URLs are in column B and the categories will be in column G. A list of categories can be found in the Categories tab at the bottom. The ideal candidate for this project should have the following skills and experience: - Strong organizational skills and attention to detail - Proficiency in using excel and categorizing data - Ability to work efficiently and accurately with a large volume of URLs (more than 1000) - Familiarity with

... promotion and price strategy) for the primary target, in terms of your creative input? Also, present segmented bar charts (see example below). Week 4-2 Segmented Bar Chart Week 4-2 Segmented Bar Chart Running an ANOVA with excel: First identify which variable you would like to work with. Put the data of the specified variable for each cluster into a separate column. Click on the Data tab at the top of the screen and then click Data Analysis on the right-hand side. ANOVA-step ANOVA-step Then select “Anova: Single Factor” ANOVA-Single ANOVA-Single It will ask for Input Range. Identify the top leftmost box and bottom rightmost of the table you created in Step 1. Type these box labels as such - top leftmost:

I need to convert a specific column of an Excel file (column H) to a PDF. I don't need any additional formatting or styling, just the conversion of the column as it appears in the Excel file. I need the PDF delivered within 24 hours.

Project Title: Small PDF change. Remove column Description: - The client is looking for a freelancer to make a small change to a PDF file by removing a specific column. - The client has provided a screenshot indicating the specific column that needs to be removed. - The client has confirmed that they have the original PDF file. - The urgency of the project was not specified. - The ideal freelancer for this job should have experience in PDF editing and be familiar with tools/software for modifying PDF files. - Attention to detail is important to ensure that the correct column is removed without affecting the rest of the document. - The freelancer should be able to work independently and deliver the completed project within the client's desired timeframe, as...

I'm looking for someone to help me with my two scrapy codes to scrape the product variants. It is also important to note whether the product is available or not. If a quantity is specified, the quantity should be entered in a new quantity column. If no quantity is specified but the product is available, 1000 should always be specified, and if the quantity is not currently available, quantity 0 should be specified The scrapy codes have already been written and all that is left is to record the product variants. The product variants should be listed under the main configurable product in the JSON file. A complete example of what the result should look like is also included and should be followed accordingly For the products that are variants, the main product for which the ...

**Project Description:** We are seeking a skilled data visualization expert who can help us rearrange and visualize data in Tableau. The specific task involves positioning a field that contains the difference of two values (quarterly data) in a column-wise format at the end of the data set, as illustrated in the provided snapshot and Excel workbook. Your expertise in data visualization and Tableau is essential for this project. **Deliverables:** - The Excel data set with the field rearranged as per the project requirements. - A Tableau visualization that effectively presents the rearranged data and highlights key insights. - Documentation explaining the data manipulation process and any specific visualization choices. We are looking for a data visualization expert who can effi...

I'm in search of someone who can...data when importing it into Excel. Here's a quick example of what I need: 1. Input (PDF file to upload to Google Spreadsheet): Attached to this post. 2. Output (the spreadsheet): Data parse example: a. Discard the pages without a table. b. Remove the row without cells (dates) c. Split name in 2 different columns (first name / last name). d. On column "C", exclude rows with strings that starts with a "K". e. Column D, remove the "MIDD-" string. f. Remove unnecessary columns. g. Add a "-" to the "PIN" number. If you think you can assist with this, please let me know, and I'll provide you with extremely detailed information about the project. It's a project that n...

...Capability to generate its training data from a plethora of sources including PDFs, CHMs, HTML documents, Google Docs, user forums, websites, blogs, and even training videos. • Incorporate image recognition to extract and interpret data from visual sources. 8. Interop Library Integration: • Allow interfacing with external interop libraries, enabling direct code verification or program manipulation. • Macro Recording through the Interop Library: Implement a feature to record macros through the interop library, which can serve as bot training material, enhancing automation capabilities. 9. Chat History and Revisions: • Maintain a comprehensive record of chat history and coding revisions, ensuring traceability and accountability. • Users should be able to ...

I'm looking for someone to help me integrate a chat GPT API into my Google Spreadsheet. I will provide the API key, and will not need to use a template. I only require access to one chatbot. The successful contractor mus...to use a template. I only require access to one chatbot. The successful contractor must be able to demonstrate a high standard of work and an understanding of the API in question, as well as integration into a Google Spreadsheet. I look forward to hearing from you. The project is simple. There is some data in the lines of Column "A" of the tab "Input". This data is the command (input) of Chat GPT (). The response of the API must be inserted in the lines of column "A" of the tab "Output". Each paragraph of the ou...

The application that I have uses a table to display data. I would like this data to be filterable and sortable. Each column in the table needs to have an input field. When the user types, the data in the table should show and hide depending on the entered search term. Your solution should also have the ability to combine filters from multiple columns to get a very granular result. The solution should return a result where ALL filter conditions are met instead of any of the filter conditions

My project involves creating a PDF file from data stored in an Excel column. The data stored in the Excel column is text, and I have a rough idea for the layout of the PDF file but I am still open to suggestions. I do not require any additional elements to be added to the PDF file, like images, graphs or tables.

I would like a CSV / excel file of a list of up to 500 Telecommunication and Media Companies (such as Vodafone or Orange) and their emails. Rather than a generic company email, it would be ideal to have an email of a contact at the company, for example, the CEO or Head of Marketing. Ideally a three column sheet with name of company, name of contact (ex: Head of Marketing), and company contact email.

I would like a CSV / excel file of a list of up to 500 Financial Service Companies (such as Quicken Loans or Wells Fargo) and their emails. Rather than a generic company email, it would be ideal to have an email of a contact at the company, for example, the CEO or Head of Marketing. Ideally a three column sheet with name of company, name of contact (ex: Head of Marketing), and company contact email.

I am looking for someone with web scraping and research skills to help me populate contact information. I attach an excel file with 52.305 rows. You need to do a preliminary cleaning: you have the first column "Unique Identification Code" that you must use to cancel the duplicated rows. (see details in the file itself). You'll obtain 21.044 rows remaining as basis tor the web search. You can do the search using google or maybe specific web site such as or In case of multiple answer, please use the Zip Code to do the right choise. Please, if you are interested, answer producing a sample for the first 30 rows. I will NOT answer without the sample. Please DO NOT DO unrealistic quotation just to start discussion and

I am looking for an experienced .NET WinUI developer who can create a custom datagrid with specific functionality and a unique layout for the column headers. The project requires the following: Functionality: - Grouping and summarizing data in the datagrid Column Header Layout: - Two layers of column headers stacked vertically Timeline: - Completion of the project within 1-2 weeks Ideal Skills and Experience: - Strong proficiency in .NET WinUI development - Experience with customizing datagrids and implementing advanced functionality - Familiarity with grouping and summarizing data in a datagrid - Ability to create a unique layout for column headers If you have the necessary skills and experience, and can complete the project within the specified timeframe,...

I am looking for someone to build me a mobile app for a payroll management system that would be compatible with both iOS and Android devices. My ideal app would...system that would be compatible with both iOS and Android devices. My ideal app would have integrations for payroll processing including employee information, so that their salaries can be calculated and administered according to their working hours including tax which should be present in the dashboard their work timing and performance. One more point is that if an employee is working good then increment in salary or promotion this should be under administrator's control. I would like the design of my app to be simple and intuitive so that employees can easily enter data related to their jobs and service hours with ...

...Accurate and timely completion of this project is essential. If you feel that you can fulfill this task, please contact me to discuss further details and project progress. Background: I have two data sources. 1. A Pubmed download, consisting of 441848 rows (each a journal article reference) and 44 columns (Unique ID, Author, Year, Title, abstract, Keywords etc) The Pubmed output keywords column contains all words by which each article is marked. 2. The list of Medical Subject Headings (MeSH) is from the United States National Library of Medicine. MeSH is a hierarchical framework. The MeSH list contains 36056 rows listing the keywords from the 16 areas by which papers are classified/codes (Anatomy [A], Organisms [B], Diseases [C], Chemicals and Drugs [D] etc) Some he...

I am looking for a person to validate the data between Image file and an excel file, wherever mismatch is there highlighting the column (Particular font color) with red color is required. Skills and Experience: - Proficient in Excel - Attention to detail - Experience with data entry and verification Data Verification: Process : 1. Validate the data between Image file and the excel file 2. Where ever there is an error, you need to highlight the cell font in RED color in Excel sheet and share the same (Sample Image file and Excel file - Screenshot were attached) 3. Spaces to be considered as an error 4. Upper case and lower case mistakes to be considered as an error 5. Spelling mistakes to be considered as an error Delivery Process : Time Period : 1 Day Payment Terms (Mandato...

I was responsible for inputting large datasets into Excel, ensuring accuracy and consistency. This involved tasks such as data validation, text-to-column operations, and removing duplicates to maintain clean and reliable data.

I am looking for a VBA expert who can help me connect MS Word and Excel and create a user interface for my project. The ideal candidate should have experience in performing data analysis and manipulation using VBA macros. Specific tasks for the VBA macro: - Connect MS Word and Excel seamlessly - Create a user interface with a specific design in mind Level of complexity of the data: - Intermediate data, including tables and charts Skills and experience required: - Proficiency in VBA programming - Strong understanding of MS Word and Excel integration - Experience in creating user interfaces with specific designs - Knowledge of data analysis and manipulation techniques using VBA macros If you have the skills and experience mentioned above, please submit your proposal.

I am looking for a SharePoint Developer who can: Apply Column Level Security on Excel Sheets we have in sharepoint

Hi Sayma T., I noticed your profile and would like to offer you my project. We can discuss any details over chat. Process : 1. Type as it is from image file to excel file, No need to change any thing. 2. For every single image you need to use single excel file. 3. All excel file name should be given same as it is on the image file name 4. Date of birth column need to type on text format. 5. Upper case or lower case (caps or small letter) should be typed respectively,else it will be considered under spelling mistakes. 6. Spaces are also important, additional space is provided where its not required then its considered as an error. additional space is NOT provided where its required then its considered as an error. Delivery Process : Time Period : 1 Day Payment Terms (Man...

...files - Ensure accurate data transfer Skills and Experience: - Proficient in Excel - Attention to detail - Experience with data entry and verification Process : 1. Type as it is from image file to excel file, No need to change any thing. 2. For every single image you need to use single excel file. 3. All excel file name should be given same as it is on the image file name 4. Date of birth column need to type on text format. 5. Upper case or lower case (caps or small letter) should be typed respectively,else it will be considered under spelling mistakes. 6. Spaces are also important, a. If additional space is provided where its not required then its considered as an error. b. If additional space is NOT provided where its required then its considered as an error. Deliver...

I am looking for a skilled PHP developer who can create a...accurately sort and filter emails - Familiarity with Gmail API's documentation and best practices The end project will have our involvement, once the emails are stored in the database, a cron will run over new rows, running ChatGPT to detect spam, sales emails, etc and categories emails. This cron and the ChatGPT script will be done by us. We just need the data to be in the database. Once the column "status" in the database is 1 (for finished) your script will then trigger, if the "response" says spam, it will spam it, if it says a folder name, it'll put it in that folder, if it says a label it will assign it that label. We will need oAuth for this project, we are developers, so we can assis...

...am looking for a freelancer who can convert an excel LSD list and plot it on an interactive Google Map under Lists under Saved places.. To start I want to work off a 2 row spreadsheet with company name | LSD and plot each company under a separate list. I often have to visit multiple LSD's in a day and it would help to have automation be able to help plot the list completely. example column A: company A column B : LSD A The software should create a list "company A" and plot the "LSD A" as a saved location. If multiple companies are present in the sheet, multiple lists should be present on google maps. IF possible, I would like to be able to label each site under the LSD instead of "Dropped Pin". This can be done under either dropped pin...

I am looking for a freelancer to create an Excel file that inputs city and state information when a zipcode is entered for example Column B would be the address, for example ( 1 EAST ST, 95023 ) column c is the city, column d is thate state ( abbreviated) and colume E is the zipcode. Format: No specific format in mind, open to any format suggestions from the freelancer. Data: I will provide the zipcode data for the Excel file. Coverage: The Excel file should cover more than 500 zipcodes. Skills and Experience: - Proficiency in Excel and data entry - Knowledge of zipcode databases and how to integrate them into Excel - Attention to detail to ensure accurate and complete information input - Ability to organize and structure data effectively in Excel

I am looking for a freelancer who can help me with mobile automation on the Android platform. The automation will involve selecting and saving a list of column data based on an excel sheet. There will be more than 5 different data sets that need to be selected and saved. Ideal skills and experience for this job include: - Proficiency in mobile automation on the Android platform - Experience with handling and extracting data from excel sheets - Attention to detail and accuracy in selecting and saving data sets - Strong problem-solving skills to handle more than 20 different data sets efficiently

Hi Milan S., as discussed on chat this project involves making some macro's to import data and generate charts plus export to jepg.

Project Description: SQL Server Column Validation I am looking for a skilled SQL developer who can help me with column validation in my SQL Server database. The main purpose of this column is verification. Data Type: - The column will store various types of data, including text, numbers, and dates. Validation Rules: - I am open to suggestions for specific validation rules for the column. As the purpose is verification, I need recommendations on how to ensure the accuracy and integrity of the data stored in the column. Ideal Skills and Experience: - Strong experience in SQL Server development - Knowledge of data validation techniques and best practices - Ability to recommend and implement appropriate validation rules for different data types -...

I am looking for a freelancer to fix an error and make modifications to an existing Excel Macro. The specific issue that needs to be fixed is an incorrect calculation. Modifications: - I would like to improve an existing feature in the macro. Requirements: - The freelancer must have experience in Excel Macros and be proficient in VBA coding. - Knowledge of Excel functions and formulas is required. - The freelancer should have experience in fixing error of Vlook up in Excel Macros. - Attention to detail and the ability to debug and troubleshoot code is essential. Please note that the existing Excel macro code is available and will be provided to the selected freelancer.

Hello, I have a database that is used in accounting software. I would like to understand how it works. When I open this database I see that there is the activate content banner, but when I activate it I find no macro. How can I display the active content? If you can figure it out, I've got a lot of work to give you so that I can understand how the software works.

I am looking for an Excel VBA expert who can create an automation macro for me. The purpose of this project is to streamline our communication processes and increase productivity by automating the creation of Outlook emails with PDF attachments. Specific details about the project include: - The client has a specific format or template for the Outlook emails, which will be provided to the freelancer. - Although the client doesn't require any specific information or data to be included in the PDF attachments, they have some preferences which will be shared with the freelancer. Skills and experience required for this project: - Proficiency in Excel VBA and automation. - Strong knowledge of Outlook and email automation. - Ability to work with templates and create customized em...

VIDOTN ADDITION Sept 19 2023 We need 2 pictures added to the VIDOTN Profile after the identity is verified. 1st and last, or last if there is only 1 Project Insurance MedicaidAID USA will sign up as a Merchant. We need anyone signing up as a Member to have Healthcare USA as a service on the Welcome page on the right hand column at the bottom How it works for individuals looking for assistance from a medical professional. If the intake person must be is signed up as an MEM or they must do so. The Intake Person y enters the patient’s first name last name address city state ZIPcode email address, Health insurance coverage Yes NO, cellphone and cell provider into a for and sends it to WebPicID. The intake person sens this info to WebPicID by Secure Message Ray Grace intake...

I would like the attached spreadsheet to allow me to check one of the three statements for each topic to grade a student and tally up their total points in Cell G8. For each topic I will select the text either in column B, C or D. I would like the selection to highlight in a color. I would like the selection to be dynamic so if I later change to a different selection. Points are tallied for each topic. Column B: Meet Expectations is worth 3 points, Column C: Approaching Expectations is worth 2 points and Column D: Needs Improvement is worth 1 point. I would like the total points to be displayed in cell G8. See tab Student 1 for an example of what I want it to look like after the cells are selected. I want to make a copy of the sheet for each student.

I am moving my server but it has this error: Error SyntaxError: : unexpected character at line 1 column 1 of the JSON data I am using and

I am looking for someone to help me with an Excel filter issue I am having. I am working with numeric data, and the specific problem I am encountering with the filter is that it is not showing all the data. I need to be able to apply a filter to every option under every column, so that I can view the data more effectively. If you have experience and expertise in troubleshooting Excel filter related issues, please let me know.

...PRODUCE RESULTS THEN THIS IS NOT THE PROJECT FOR YOU. I am looking for a freelancer who can add line graphs to my excel sheet. The data is simple and I have specific data fields that I want to be included in the graphs. My example graphs are on the Graphs tab. Data to be added is in column A in Graph Data Tab starting in row 79. I have already produced row 79 and row 80 graphs. Macro must stop at space below (row 260) and process only visible rows. Macro must be able to start where I put my cursor in column A. I have another section to process and these graphs will be in the next space to the right of previous graphs as shown in the example I have multiple sections to add which are not on this spreadsheet. I need the code to process this new data whic...

Here is the page: I would like you to please add 1 additional column as I will SHOW you in this VIDEO: Thank you Jim

Work is simple. Need to use a drop down to select a record and in another column just have to give a code to select a area name and then just give save. Need to do it for 5000 records. Since this is a time consuming work I would be picking up multiple resource for urgency A 100 record update can take around 12 minutes. Work needs to be started immediately. Calculate based on that and bid it.

I am looking for a structural engineer to design a residential building based on my detailed plans. The project needs to be completed within 1 weeks. Key requirements: - Experience in designing residential buildings - Proficiency in structural engineering principles and software - Ability to interpret and incorporate detailed architectural plans - Strong attention...Ability to collaborate with architects and other professionals involved in the project - Excellent communication skills to ensure a smooth and efficient process If you are a skilled and experienced structural engineer who can meet these requirements and deliver high-quality results within the specified timeframe, please submit your proposal. I have Auto CADD drawing, I need Foundation, Beam, Column and slab Structura...

I am looking for a freelancer who can convert a 10-20 page Microsoft Word document to Overleaf two column. The ideal candidate should have experience in converting documents and have knowledge of formatting requirements in Overleaf. I will provide the criteria and information. Requirements: - Experience in converting Microsoft Word documents to Overleaf - Knowledge of formatting requirements in Overleaf - Ability to complete the conversion within 2 weeks

I am looking for a skilled freelancer to create an interlinked Google Spreadsheet Macro software for me. The main requirements for this project are data entry, sharing and collaboration, as well as high level security measures with multi-factor authentication. Specific features needed for this software include: - Data sharing capabilities to allow multiple users to access and collaborate on the spreadsheet - The ability to input and calculate data within the spreadsheet - Data visualization and charting capabilities to present the data in a visually appealing way Additionally, I already have some data that needs to be integrated into the software, with the intention of adding more data later on. In terms of security and privacy, I require high level security measures with multi...

Project Title: VBA Macro modification Description: I am looking for a skilled VBA developer to modify Macro 1 within a tight deadline of 24 hours. The specific modification required is to add new features to the existing macro. Skills and Experience: The ideal candidate for this project should have: - Strong proficiency in VBA development - Extensive experience in modifying VBA macros - Ability to understand and work with existing code - Attention to detail to ensure seamless integration of new features - Ability to work under pressure and deliver within a strict deadline

...PROFESSIONAL LOOKING Checkout PAGE/PROCESS 2.) Bug fixing a) Product Code shows "Array" on order email confirmation. b) Product Name/Code of the product variants are not searchable on the search field on homepage. DISCOUNT ROLE PAGE c) Product codes should be searchable including variants product codes. d) We should be able to pick specific product variant in the select products column (Currently discounts only apply on the parent product instead of one specific variant) e) Discount value should be in Australian Dollar/Currency instead of percentage Ideal Skills and Experience: - Strong knowledge and experience in Woo Commerce and WordPress development. - Proficiency in PHP, HTML, CSS, and JavaScript. - Proficiency responsiveness of the theme...

...am looking for a freelancer who can convert an excel LSD list and plot it on an interactive Google Map under Lists under Saved places.. To start I want to work off a 2 row spreadsheet with company name | LSD and plot each company under a separate list. I often have to visit multiple LSD's in a day and it would help to have automation be able to help plot the list completely. example column A: company A column B : LSD A The software should create a list "company A" and plot the "LSD A" as a saved location. If multiple companies are present in the sheet, multiple lists should be present on google maps. IF possible, I would like to be able to label each site under the LSD instead of "Dropped Pin". This can be done under either dropped pin...

I am looking for a freelancer who can make a PDF file fillable for collecting user information. Design: - I have a specific design or layout in mind for the PDF file. You must make it so that the user can fill in the information on the PDF. The top row and the column on the ride-hand side would all be fillable by the users who open this pdf. Information Complexity: - The information to be collected is basic information about learning strategies. Skills and Experience: - Proficiency in creating fillable PDF forms - Experience in designing user-friendly and visually appealing PDF forms - Knowledge of form validation and data collection - Attention to detail to ensure accurate data collection - Ability to suggest design improvements if needed If you have the required ski...

Project Description: We are looking for a freelancer who can help us automate the process of saving an image to a specific field in monday.com. This will be used in a material inventory database that is being created so an image of each item can be easily saved to the correct field within that items column. The project requirements and details are as follows: Image File Type: - The image file that needs to be saved is in JPEG format. Specific Field: - The image will be saved in a specific field called "image" in monday.com. Automation Platform: - We do not have a specific preference for the automation platform to be used. The freelancer can choose between Zapier or Integromat based on their expertise and suitability for the project. Skills and Experience Required: - E...