I have an existing excel workbook where the certificate has been revoked. I paid an excel expert to build the macro and about 2 yrs later, the person shut down their business. Weeks leter the certificate was revoked and now the macro won't work. I need either to fix the certificate or build a new macro which is a basic 5x5 matrix - two codes- which
...backlink or I will share list of sites where they will have to do. I will be sharing task daily or twice or thrice in a week. Candidate will make a worksheet what they have done and put all links in excel sheet what they have done. So this is not the project basis job its based on instruction given by me or my team. You will be given articles but you
I need a freelance developer who is very familiar with Bloomberg functions in excel (mac and windows). I need someone who is based in Dubai. Please send your CV with professional picture to firstname.lastname@example.org.
Need an excel VBA that can highlight duplicate emails for multiple rows. I know Excel's built in "highlight duplicate" already highlights the exact value of 1 cell to another. But what I need is a little different: Some of my cells contain only 1 email ad, while some contains multiple email ad in one cell, separated by semicolons. What I need is
...As Range Dim xCol As Long On Error Resume Next [login to view URL] = False Set Rng = [login to view URL]("Please select the url cells:", "KuTools for excel", [login to view URL], , , , , 8) For Each cell In Rng filenam = cell [login to view URL](filenam).Select Set Pshp = [login to view URL](1)
The excel file has VBA functions. So make sure VBA functions not corrupted. I need an excel expert how can do this with carefully. Also I need some translation in the excel file. Just need to translate from Russian to English. After that I need this file work on google spread sheet. So that it should work online from any where. Attached the file. It
Required; 1. Remove rows based on 2 criteria (if Col R (text field) is blank and Col E (Numerical quantity) is 0) 2. Sort rows based on Col N (text field) - ...based on 2 criteria (if Col R (text field) is blank and Col E (Numerical quantity) is 0) 2. Sort rows based on Col N (text field) - increasing sequence. There will be 1 worksheet in the file.
I need the expert for Python 3, PostgreSQL 10, API integration and VBA knowledge an absolute MUST. Details will be share with winning bidder. Please bid if you are expert.
...specific data on a daily/weekly basis. Based on the few conditions , it has to be put into specific cells in the main database with minor manipulation. Looking for an expert excel/VBA freelancer to assist . Sheets DQ-45, DQ-46, DQ-47 & DQ-48 are identical. However they represent 4 different people who move to various locations . On each location various
...automate tasks in Excel by writing so-called macros. This is for a project repeated every 3 months. Attached are the spreadsheets we have put together. I also attach the end result which gets fed through the excel information. We take the financial statements for ten banks in one given country. We then input all info on to the excel model. Only on the
...photo shop files and how to make good book eCovers - The free lancer can buy an eCover from FIVERR for $5 and change it to be the eCover for my book - the freelancer has to find the right design that fits the topic and send me the link and I will buy the design files from FIVERR and send the freelancer the PSD file to change around... or they can change
we have a database in Microsoft Access and we want relied this a management planning for our drivers. please disc...Microsoft Access and we want relied this a management planning for our drivers. please discuss in private for more details not need you share with me your other skills, I want only VBA developer and if you share other skills I not reply
I need a VBA script that will use the spreadsheet and create outlook emails that will send to each individual recipient listed. Example email body: Hello, I see that PO# (value from spreadsheet) was not picked up yesterday. Can you please advise if this freight is ready for pickup today?
...WHO CAN GET ME EMAILS DATA FOR CEO,CF0,purchasing/procurement manager of companies in USA & CANADA. We would like an excel spreadsheet of CEO, CFO $ PROCUREMENT /PURCHASING MANAGER emails of USA & CANADA COMPANIES. The worksheet should include the following columns for data entry Column A: COMPANY NAME Column B: CEO FIRST & LAST NAMES
I would like an excel spreadsheet that calculates the best fantasy Football lineup based on 50,000 salary cap, player costs, 1.5x salary for captain choice, FPPG, and OPRK using the Draft Kings platform. The worksheet should include the following columns for data entry Column A: Player Name Column B: Salary (Player Costs) Column:C FPPG -(FPPG
I am an individual who wants to develop a prototype app from an Excel which uses a VBA uder-defined function. I have no plans to make this commerical yet, I just want to see what is possible and at what price. The minimum viable app will be called "Mr Simple" and will need to work on Android and iOS entirely offline and the app must be capable of
Need someone expert in Excel. I have an excel file and i want to translate it in English. Also it downloads data from web, and i need to have it online, so i need to transform it into a googlesheet file.
Need a macro to connect to teradata database and execute the S...connect to teradata database and execute the SQL with the input given(like year month and option). And append the resultset into the same excel in different worksheet. Keep latest 12 versions of data in that worksheet. If possible, we need to get the automatic selected items in pivot.
...alphabetic variables ranging from 7 to 60. Objective is to create various permutations of those values by combing values between certain columns using a specific logic with a number of conditions and exceptions. For example: combined values from columns A, B and C except if a value in column B=X, then only pick values from column Y that containY. Example
Related to canteen management. Create a worksheet using excel maintaining the monthly expenses of the canteen under various heads, for a year. it should contain: •Formulas that automatically calculate •You must find the average expenses per month •Automatically find the month when the minimum amount was spent. •Create a chart for head wise expenditure
Hi, I have a VBA code written in excel file (macro). It performs the calculations. I will provide you the code and I need someone to provide detailed description for each line of the code. (eg. how code works, what each line does, what each line means etc.)
I just need a form where I can enter details and that should be added to my access database, it's very simple. You should only use VBA code in MS Access, no other language or inbuilt feature of MS Access. I will give you all the table related information
Need VBA to sum numbers. First, the VBA looks into column B to identify product category. After it looks into column D. In column E it creates the sums with a MAX value of 800. As you can see on the picture we have many sums within the same product category.
Hi there! I have been working on an excel vba macro that transfers data from one workbook to another. The part that I am stuck on is how to transfer several rows of data from one workbook to another and at the same time setting things up so the next time data is transferred, it will go under the previously transferred data. The majority of...
...without looking at attached worksheet. If you do, I won't even consider your offer. I have written a complicated pricing program in Excel and need assistance finishing it. For this moment you are bidding on debugging the macro "Building 1" Located on the "Quote" Worksheet. The winning person will: *Have advanced knowledge of Excel. *Be able...
I am looking for a Voiceover for my Alcohol Recovery book. Please apply with a sample of your voice. Only native English speakers. Female voices are much preferred. Estimated budget, 85 USD. Words: around 14.000 Delivery within 5/7 days. Start your application with the word 'Butterfly', otherwise, we won't consider you. You'll accept to read a 1-page document of the demand...
Hi Balint K., I noticed your profile and would like to offer you my project. I have a excel workbook. With a VBA userform data is inputed into a master table. Additionally I also wanted it to copy that input to diferente sheets depending on one criteria (like master table all inputs, then if is about car also copies to car sheet but if is motorbike
Desired output is an Excel (Mac Version 14.7.7) spreadsheet which prioritizes restock from vendors by sales volume and/or profitability. Inputs are two data files exported from Quickbooks ("sales" and "stock") which are attached. Note that these data export files can be modified to some degree if required. Also, "sales" data file includes data for...
I need a faster VBA macro. It's important to mention that the data I intend to scrape needs expanding to view the data required. It's like vertical tabbed content if you will. XML http is faster you can use it or other way but goal is fast vba. Apply if you can deliver this and pls do so within my budget.
I have 9 InDesign files which need some items switched out for some items from several other InDesign files. Each page of the 9 InDesign files are broken up into categories. You would just need to look at the items on an Excel worksheet, find the items in the supplied InDesign files, and then copy and paste the items in the final InDesign file in the