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
...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 will copy
I am looking for a 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.
...in the processing 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
Looking for an experienced Bot Developer to teach me 1 ON 1 (I've basic experience), How to build custom-made bots for web automation processes such as scraping, posting ETC. MUST HAVE PRIOR EXPERIENCE IN BUILDING BOTS FOR WEB IN JS / PYTHON. * Looking for a long-term tutor
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
Please see attached input spreadsheet and output spreadsheet. - Create new WS "Aggregate" & "Volume" - For each worksheet matching "Data-*" - Copy and Transpose cells area matching "Host Name:" to "Aggregate" WS - Copy and Paste cells area matching "Aggregate Name" to "Aggregate" WS - Forward fill cells area matchin...
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
...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 June 2018 file is changed. It also needs to work if regardless of how
...a research project and need to scrap some information from this website: [login to view URL] WHAT I WANT TO DO First I want to scap data from the job marketplaces on a daily basis. 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):
Module required to split UK postcode (zip codes) as per attached spreadsheet. The table on left is an Access table. The yellow table on r...GL1-4,7,14,16-20,50-56, HD, HR1,4,6-9, HX, L, LE, LN1,5-6, LS, LU, M, MK, NG, NN, OL, PE1-11,13-16,19,26-30,38,99, PR, S,SK, SN1-7,25-26, ST, SY1-4,99, TF, WA, WF, WN, The project needs to be uploaded in Access.
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.
An Excel spreadsheet on an iphone is being further developed and assistance with coding for two columns is requested. IMPORTANT: Due to the limitations of Excel running on an Apple Iphone environment no VBA code can be used. The two columns to be coded draw on the surrounding columns to decide what data populates each cell.