Working off an excel list of contact names and email addresses, find the contact's title online and fill it in next to the contact name/email address on a spreadsheet. Most of the contacts are government employees who work for public schools. The ideal freelancer will be ok working with highly repetitive steps. Attention to detail is key as you can
Hi. I would like to combine 4 word files into 1 word file and convert it into pdf and save it under today’s date. Users would like to run a macro and have this done on a daily basis. The naming convention of the 4 word files will be as ‘Work of xyz 06-15-2019’. We would then need to convert these 4 into 1 word file and convert into pdf & put it in the respective month’...
...morning. This is a small app managing 16 units only in excel. I want it to print form, such as annual and monthly balance sheets, reports, keep data, late fees, show late fees, who's late, to browse through the different sheets(month),etc. I already have the frame of the program, it is advanced. An excel expert can tweak it a little bit to his/her convenience
i need to copy data from website to excel file like company name - address - telephone - area- open and close time and paste to excel file but these website with Arabic language need to collect 10000 company data
You need to add some information to the other columns of this file. The information are included in the prior columns. content for Column M: * you need to put here the figure here, which is found in column F. For example, in column F „50 ML" then you need to fill in column M „50" content for Column O: * you need to check if in column H you find one of these words, if so you n...
...of the product range is available for customization when ordering and is done in Excel. The orders forms include higher level excel functions such as index and match functions, conditional formatting requirements and various lookups. This task suits higher level Excel competency and also includes some macro requirements. It is also preferable to have
Hi, I need a database for medicines sold in India in the following format that covers all streams of medicine. Brand name - Composition - Form(Tablet, syrup, ointment, injection,etc) - Strength - Generic alternative I have a strict timeline to close this so, the sooner the better.
Please refer to the attached file
... 2. Cell B1 is an input cell for how many iterations i want to run 3. Starting in row 7 is pasted value data of one iteration of the data in row 3 I want a simple VBA code that will loop through a procedure to copy and paste value row 3 data determined by the number i put in cell B1. I also want to add a status bar at the bottom of the sheet that
Hello Freelancers, Our company furnishes and rents out apartments. Therefore we need to create standardized xls "buying lists" listing all the items we need to order per apartment. We are looking for talented freelancers to program us a smart buying list. your job is to program an xls which can do the following: - item category (bedroom, kitchen, living room, bathroom, corridor, balc...
I have 10 excel sheets with around 10,000 columns each. I need each sheet broken down into sheets with 3,000 columns each and named 0-2,999 3,000-5,999 etc. I need the first row to have the column headings as well. So I will send you 10 documents, you will send me back 30 or so documents, each having 3,000 lines of data on them. JOB MUST
Very simple task where you get a list of usernames on Instagram and need to add the persons first name to the excel file. Write "I am ready" in the first line of your proposal to get started.
Hi there, there is data I would like to scrape from a website that uses a websocket API. I would like the successful applicant to create some code to get the data I need by ONLY USING VBA OR POWER QUERY. Please do not apply if using any other platform.
Attached is the sample project I've put together. I have some VBA code as well. Currently I need to apply the formula for 25 rows, and if a3 value changes b3 should say Please select, if b3 changes c3 should say Please select and if c3 changes d3 should say Please select. I am kind of stuck to implement the VBA logic in the speardsheet
I'm looking for someone who can take an Excel spreadsheet with two worksheets and compare the two tables in the worksheets and pull data from the columns of one spreadsheet into the other spreadsheet. For example, both spreadsheets have a list of applications. The bigger spreadsheet has more applications in the list, and it also has two columns (dependencies
Need to add 90 new translations for portfolio items. Only copy-paste job. Translations already made.
I have some work, in an Excel spreadsheet.
We previously developed the below formula which produced the banded decimals in the final column below (also attached): =IF(G3="","",IF(TIME(IFERROR(MID(G3,1,SEARCH(" hour",G3)-1),0),IFERROR(MID(G3,IF(ISERROR(SEARCH(" minute",G3)),0,IFERROR(SEARCH(" hour",G3)+IF(ISERROR(SEARCH(" hours",G3)),5,6),0)+1),IFERROR(SEARCH(" minute"...
Excel Database /Finish/Design/Complete for tracking construction projects
Our Cooperative society needs an Excel spreadsheet that can manage data and process; -6 different sign up plans(e.g Gold,silver etc), with an MLM compensation plan for members who enrolls others. A loan management formular must be integrated to allow for loan management (loan approval, calculation and repayment). The MLM matrix should be 6 (width) by
Need to create a work sheet to record purchase orders auto generating PO numbers with approval levels. If cell F2 is greater than £500 approval required. A third person needs to access the WS and authorise the PO [login to view URL] the order is less than 500 then A2 is populated with the auto number created in N2. If over 500 reported as approval required until J2 is completed (this cell a...
I have a quick and easy task in an Excel spreadsheet. All figures are already entered but I would like a formula created so that I have a monthly and yearly total as well as graph showing total amounts including profit. In addition it to be reoccurring yearly total
Hello Team. Looking for a small webpage with excel sheet at the backend for the data. The webpage will have scroll down manu, calendar , user input text box , Another text box. These elements will connect with excel sheet. we have to appscript.
...keyword ideas in a niche and enter the information into an excel sheet. Based on my personal experience, I anticipate that this project will take between 2 - 3 days to complete. A video tutorial of the work will be provided to selected candidate. Workflow: - Candidate will receive and excel sheet with keywords to research - You will login into an online-based
Creating a spreadsheet of contacts from an online public website: - First name - Last name - Company - Address - Telephone - Email Spreadsheet template and brief to be sent on hiring with url and search criteria. 1,000s of records to be created. Immediate start. May be other database-related work available.
I have attached three types of d...I need a template made that will look the same and be able to be converted to a PDF for submission, but I want all the variations of the document to be on separate pages of excel and only have to enter in variable details on one sheet then the macro carrys it to every other variation please see areas hilighted yellow