I need a Macro to check if for each ID under column E, (Type) "Services" exists, if it does, then any other row that has same ID should be deleted. If no type "Services" exists, then all values under Column C (value) for that ID should be deleted and replaced in one cell (whichever cell for that ID) by the amount that is in one cell in column D (amounts are always the same for ...
1. From within an active workbook within Visio 2010 I require a macro to link to an active excel worksheet (if possible the macro should prompt the user to select the worksheet / range) and for each entry within a list create a page in Visio for each 2. From within Visio Macro to copy a master template into each new page that has been set up in the active Visio workbook. If possible the macro wil...
I am looking for a developer that will help to create me scrips that will import and filter from phpmyadmin to excel based o...developer that will help to create me scrips that will import and filter from phpmyadmin to excel based on values in excel cell A1 and B1. Must be knowledgable in PHP, Excel, VBA, and Phpmyadmin. Bid and let's discuss further.
...of converting several excel workbooks that have extensive VBA coding into Visual Studio with C#. I'd like to start with two `Forms` to see how it goes and then decide on the best course of action from there. The requirement is to have the programmer setup a VSTO project, then convert the VBA user forms into C# windows forms. If this is some thing
I have existing Django project that i need good reports and Dashboards
Hi, I recently started learning VBA and need some help with some code. I have around 16 columns of data, that needs to be filled in with a help of a User Form. I came so far that I have created the userform and can fill out all rows correctly, so I have coe for that. However for some of the columns I would like to have a combobox instead of a textbox
Hello, I am looking for a Excel VBA specialist who can help me with a project. I want to have certain macros work from the first time I open a workbook until about 2 days. Depending on the total listed in sheet1 Column E will determine how long to extend the macro. For example if after the 2 days the total is 1 then it would work for 1 month from
...individual freelancer (please do NOT respond if you are a company). As a freelancer you MUST be a Java Script Ninja with significant experience building custom web based dashboards and reports. You MUST also have significant experience coding a customer page or report to integrate with a Commercial SaaS API. We estimate this work to take no more
...traffic/lead conversion on website Design campaign assets (e.g., ads, landing pages, etc.) informed by keyword research and embed on website (WordPress) Built dynamic, self-serve dashboards to track campaign(s) performance and visualize (Power BI) on a monthly basis Start date: ~July 2 Hours: ~10-20 hours/week Location: Richmond, VA preferred, but can be remote
I need an excel vba expert to write a code to automate data extraction from one excel workbook to another based on two input boxes where they have to put what they are searching for then the code extracts the matching information from the second workbook to the first workbook
I have created a blank table in the a worksheet -FSHT labelled GRV. Now i need a code written that will read GRV June 2018 file. There is a tab in the GRv June 2018 file called Weekly Floats. This contains around 4 different tests conducted on different dates. I need the code to copy the data from each test to the appropriate columns in the FSHT. This code needs to be able to work if the GRVN Jun...
...Second I want to check how long (in days) the job postings are available on the market places (and track the days). WHAT YOU SHOULD DO Step 1 (data scrapping): Please review my VBA sample code (attached) and update it in order to scrap the relevant data from the website. You will find a PDF-File with a description of the relevant data on the website. Step
Hi, I am looking for an excel expert who can create VBA codes to disable developer tabs and copying of excel document to another computer. Must also encrypt VBA codes and VBA password. To discuss further, please bid and lets chat.
Module required to split UK postcode (zip codes) as per attached spreadsheet. The table on left is an Access table. The yellow table on right will be the resulting query, The module needs to b run to create a query as per the yellow table. So the new row is created after each space and then at the end of the cell. Unless there is a space the group will remain together e.g. BD1-22,97-99 1 B, BB...
Have a hand me down Access file that takes a spreadsheet and uploads it to a database. now have an error and would like help resolv...database. now have an error and would like help resolving the error to find the specific place to add table modifiers as I am not strong in VBA. would probably take someone 10 minutes to figure out who is good with VBA.