...an excel expert to finish a sheet we are working on. You must have an excellent knowledge of all aspects of excel including coding, formulas and add-in. I require some editing to the existing code and it set up as add-ins which can be used on multiple excel workbooks. I also require a mapping solution for data which can be mapped using an excel workbook
...excel databases in one workbook. In the first one you have all the information regarding the shipment and in the second one the freights. For each contract a shipping instruction has to be generated. The products are 2 files: one pdf and one word, for each and all the contracts on the list, and are to be saved in a folder . In case I...
...scrape a specific website. It contains two tables with links, of which one is loaded via AJAX. All data shows up when I look in "links" and I then have to do some manual work to remove the unnecessary links. I instead want to set up a job so that I can run this task regularly. This also includes the "cleaning" of incorrect data. I assume this ...
Hi, Please take a look at the attached document. This shows an example of my 'dataset', and the layout of how I would like it to be transformed... I would like to accomplish the "End Result" with the use of a formula only - and NO helper columns. - Array formulas are also fine. ** I don't want to use macros ** ** I don't want to use pivot ta...
Hi, I have a file which has VBA functions. I need that file to be converted into google spread sheets with macros. Mean the macro should work on google sheets as it work in excel. It just need the existing macro added in the google sheet.
1. Create an excel spreadsheet using formulas without macros 2. Spreadsheet for tracking of job status 3. Able to calculate lead time against current date 4. Able to change color automatically 5. Drop down selection 6. PLEASE READ THE MS WORD REQUIREMENT FIRST
I have a FIFO (Trading ) spreadsheet ... Need someone who can review the sheet/macros make timely adjustments and be a reliable developer for future enhancements.... ( automation / Google sheet(possibly) ) For now ... I have a FIFO (Trading ) spreadsheet ... FIFO working ...calculating a sheet detailing stocks prices and buy / sell dates etc....
...first. 1) a) Construct a macro that demonstrates how a word processing feature can be undertaken more efficiently if it is automated. (i) Choose and state a text formatting feature, for example, underline text, embolden text, italicise text, etc. (ii) (iii) Construct a macro using the macro recorder. Link your macro to a toolbar button. (i...
We are into preventive health care sector. We do health screening camps in schools and corporates. So there's lot of work that is done in Excel. So we need to develop few macros to make this whole transition quick and convenient.
Dear Programmers, What I need is to make a custom program in excel or in visual basic which will do our manual procedures. we are the company where we make some campaigns and clients day. For example we will have one file (30mb) where the codes , barcodes and etc on there. and what I need is that , when we open the program it asks me to choose the
I need an excel file to filter tables in an interactive way (working with macros/vba etc.) What i need is showing different locations (tables). After clicking on an item, there appears a list of different items. And when you click on a specific item, you see few data numbers (results). See this link about vba [kirjaudu nähdäksesi URL:n]
I have an excel file in which I have done a little programming in macros. Recently i tried to add new columns in the sheet and i am pretty sure it shouldn't hv disturbed macros but still my macros code is not working. I need some1 who can come on TeamViewer and check where my code has gone wrong. Its hardly 2 /3 Pera code.
...expert in Visual Basic for Applications to create Macros in order to 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 o...
I have a list of websites that I need data to be extracted from. Apparently, the macros would need to be different for every website. Please bid for three websites initially and if goes well, will give rest of the work to you at the same rate. Please bid for 3 websites only now. Have over 100 websites for which macros need to be written. The Bid amount
Hello, I'm loo... Sql server and with C++, C# programming language. I have a project at hand; I want to build a full management system(website and software included). Based on the above description if interested kindly contact me ASAP and view the content in the attached document, ensure you enable macros to view the flowchart of the project. Thanks
We previously hired someone to auto fill in a purchase order when the product code was entered. The details were pulled across from another external spreadsheet. However, the sender of the external spreadsheet has added a column (H - Item UPC) which has thrown out the macros. We need someone to adjust the macro for the extra column and tell us how to
We need a very simple automated process for a regular task. If this can done with Macros that would be great. In our excel doc we currently have in column A : 'Surname' then a comma then the 'First name'. We need to run a script to change the order to: First Name, remove comma, input space, Surname. The objectiv...
I have a FIFO (Trading ) spreadsheet ... Need someone who can review the sheet/macros... make timely adjustments and be a realiable developer for future enhancments.... ( automation / Google sheet(possibly) ) For now ... I have a FIFO (Trading ) spreadsheet ... FIFO working ...calculating a sheet detailing stocks prices and buy / sell dates etc
...Medical tourism company in india committed towards ensuring that every client gets the right medical services. We offer a wide range of medical treatments and customize our services according to the needs of our clients. Our team of experts will make all the necessary arrangements to ensure that your stay in India is comfortable in every way. Whether it
Looking for the code for a macro/keylogger that will record both keystrokes and mouse clicks. Must be compatible with Android/WIN/MAC and preferably Linux but not necessarily. The code is to run on an Android device but records the macros from WIN/MAC/(Linux). It is permitted to have the requirement for a separate code to be installed upon the WIN/MAC/Linux
I need a Excel Macros expert for my current project. If you have knowledge please bid. Details will be shared in message with the selected freelancers.
I have 2 macros, and the keyboard shortcut no longer works. I am running Windows 7 virtual machine on a mac, using Parallels 12.2.1. Please help.
1. Tracking of job status 2. Simple excel program. NO MACROS 3. Able to automatic change color 4. Able to use current date as reference 5. Able to use calculate lead time between current date and past date
1) First macro: open all sheets in a folder and find two column names and change (mask) all data. e.g. where column name is "Account #" enter 88888888 (8 eight times) in all non blank cells in the column. 2) Second Macro: Open all sheets in a folder and find one column and change/reverse the math sign on all numbers in the column.
Need to create an excel template for creating printable proposals with illustrated graphs and tables for clients with the changeable entry variables. Macros to be used to make the user page independent of rest of the worksheet.
...The calendar on the right should show 4 weeks look ahead. The page should show an error or conflict in case of time overlap in the same room. The instructor is actually available for the mentioned times shown, but the room should only be reserved in case of client confirmation. (This is very important). The schedule of the instructors is as below:
1. Add 1 new employee to a page: 2. Check the site ’s load speed and make suggestions for better load time on the exiting hosting plan. 3. Advice How much faster the site will be if we remove few projects from site. 4. Add four photos onto the service page 5. Add two new projects to the Work page. Additional Notes: • You 'll need to
I have used Lotus 123 since the '80s to print 4x6 cards in the dairy industry. I desire to replace the old dot matrix printers and utililize Avery labels and with macros arranging the specific cells data into a simple report on the appropriate Avery label. I have 130 Amish clients whom are not technically connected forcing me hard copy reports weekly
I need a windows 10 based macro script for posting to WeChat groups. The macro will use the windows version of WeChat. I will give you access to an account for testing. I need the ability to post to multiple groups with various options. I am open to suggestions on how to make this work. Necessary Macro Options: Random Post Select Text from File
I need you to fill in a spreadsheet with data. Immediate hire for tonight. 8 hours of work with immediate start. API setup for open data imports is another huge plus. Familiarity with RESO real estate standards organization another big plus Data aggregate, standardize (if needed), data joins with unique ids. Another plus use of advanced excel methods
Interview for a job requires SAS programming skills, but although I have a masters in statistical analysis, I'm a bit rusty on SAS. Project involves 4 exercises described as: "This small test is used to identify the relevant SAS skills we required. Please follow the steps below to generate the required graphs or tables." Data sets in CSV format a...
We have an excel which has lots of data and simple macros to operate with. We need to simplify the same and to use more effectively. It is being handled by many employees and needs to be more user-friendly.
...excel data sheets. In other words, I want to have a good list of email addresses I can send out on an newsletter. However, I cannot include these 496 emails. We must remove them. They need to be removed before I export this data into my newsletter. Instead of doing this task one by one which would take hours...it's best to run a macro script to get
Hi, I run a warehouse. In order to manage our inventory dispatches to our customers, need to build Excel tool (using VBA and macro) for inventory management. Need someone who is very good with VBA and excel macros. Thanks
Manas, As we agreed, this project engagement of $15 when added to the $25 for the award from my contest #1 will bring your compensation for the successful delivery of working macros to $40 with an initial delivery date of Wed. 10/3/18.
I need some help on writing simple macros to eg - To be able to select mutiple values in a combobox to store in a single cell - Selecting values in a combobox to store in a cell by typing first 2-3 letters from a longer list of values - Extracting values from a range of cells and sorting them based on a single ...
Write 5 [kirjaudu nähdäksesi URL:n] macros, 1st of 5 posts (I will pay $25 each to 5 "winners") Contractor Instructions for writing VBA code Scope of assignment: Write five (5) relatively simple marcros in VBA that are, generally speaking, [kirjaudu nähdäksesi URL:n] formulations, then combine the coding for all into a single ...
Scope of assignment: Write five (5) relatively simple marcros in VBA that are, generally speaking, [kirjaudu nähdäksesi URL:n] formulations, then combine the coding for all into a single macro. The Code for two macros will have to identify with some complexity a paste location back into a database. I expect the coding of the first four macr...
I have a database with the Tables in it. I need work done in Macros and VBA. No SQL. See the Attached Power Point for Project description and See the Access Database and Excel workbook for examples and more explanations. I need this in the next two days ( I need it Tuesday). If your late I will give a rating that reflex that it was finished late