Hello, I require an excel expert to work on an existing excel sheet. You must have an excellent knowledge of Excel VBA, Macros and add-ins. The sheet already contains a lot of existing code which has some bugs which need to be fixed. The main part of the project is to create an add-in for mapping. This need to be dynamic. It needs to map the values
...syntax and Excel or Tableau macros in order produce mean comparison tests, graphs, and reports for participating companies. We are looking for someone with advanced knowledge of SPSS (notably macro functions, syntax and automation) AND a strong command of either Tableau or Excel. The process to be automated starts with data from SPSS, which need
I need to compáre data and provide trend analysis on a monthly basis. I will provide the data but need to understand how to do the comparison pulling different areas of sheer
Hi Snigdha, I have a few documents to convert into a standard format. Just copying, pasting, and formatting to the destination fonts and styles. Are you able to help immediately, when you get up tomorrow? :-) My budget is flexible, but I have have very high standards in terms of document quality. Let me know, please. Thank you!
OMO_Import - Error Handling when item prefix identifier does not exist in the master. OMO_Import - Remove filter before starting import (if filter is on) OMO_Import - Better copy of new columns so that formatting and Header formulas are carried across. OMO_Import - Autorun "creatlinks" macro at completion if new items are added Runsheetgen - Borders on either side of drop instances if po...
...from a supplied list, pasting a prepared message and changing the name. I need someone that can read the replies and make a judgement call if the message is appropriate. This happens each month $200 Fixed-price $$ Intermediate level I am looking for a mix of experience and value Project Type:Ongoing project Skills and expertise Data Entry Activity on this
I have two excel files with a lot of macros and formulas and different things and I can't figure out how to merge them into one file. One file has like 20+ sheets and the other file just has one sheet and I want to have them all in one file (you can move the 20+ sheets to the 1 sheet file, or move the 1 sheet to the 20+ sheet file, or vice versa).
Hi, We need a shopify and responsive design expert who can modify our website to our specifications detailed in our attached do...doc line by line and let me know if each can be completed to our specifications. Let me know that you have read the documentation and reviewed the corresponding images by pasting the last sentence of the doc in your bid
...help me to fill out Excel file with web sites, contacts and social media links. The work consists of copy pasting data into Excel file from several web sites and little bit of web search of missing data - super easy, but it needs to be done precisely, meticulously and accurately. I will provide Excel sheets with web sites, explain the process and...
slightly oblong circle is the outer edge of the logo, or symbol. A Z like Zoro's fitting barely inside the circle, with an I superimposed on it so all you see is the center I down the middle of the Z. then, a small plus symbol at the center of the diagonal slash and the I in the center, with a circle around that. and if we get into closer detail, (I would okay with a single small dot at the c...
Hello, I have an online business with all of my client records on a web portal. I need to build a database in Excel of all of these records, which requires copy/paste from the website in to excel. I have timed myself doing this, and without the help of any macros, I am able to complete one client record per minute and I have a total of 615 client records
We are using Chrome extension [login to view URL] to scrap a web site. It includes two scraping sitemaps (in webscraper's terminology), one to retrieve a list of all products from a web store, and another one to visit pages of new products and extract the actual information we need. Both sitemaps are running fine, but they are fired manually, and the list
I have an excel spreadsheet with some VB code macros that prompt the user for data input via popup screens, and output some data in a pdf format that I was looking at getting translated into google sheets. This macros that is being used to track a few different things for projects, and was interested in seeing what sort of ballpark timeframe and cost
...no longer applicable and no images. Solution: We need someone to go through all 135 blogs and remove these codes, re-add the correct images via "Add Media" NOT copying & pasting the image URL, and making sure the articles look nice with proper headings, boldings, etc. You can refer to the original site to see how things should look and what goes where
We have worked with a programmer to create a functional pdf form that we can use for proof approvals. Everything is working, but when copy/pasting from Adobe Illustrator into Acrobat, our image quality decreases (compressed). We want to carry over the functionality of our form into an Interactive Adobe InDesign form.
...join our merry band! 1. Advanced level of excel ability and familiarity of using macros, v-lookups and templates. This means that you are excellent with excel ! 2. Expert data validation skills and meticulous attention to detail. Ability to find the unusual or odd..... Data bods are good! 3. Highly resourceful in making business decisions and delivering
About a month ago I had a program made for me that finds data in an excel sheet I download daily that meets certain requirements I was interested in. Now I am looking for a coder who can automate the process of extracting further data from the excel sheets based on criteria I am interested in and paste the results into another excel sheet. I am currently
...I will require screenshots of forms filled initially until trust is built. It's a simple task, and one which could be automated/streamlined to a large degree if you use macros or keyboard shortcut software to paste the email content. (there are some small edits to personalise the emails for each business) (I use short keys lite (free) to insert
I have some work, in an Excel spreadsheet. Looking for a macros to combine multiple csv files and filter based on set of keywords and remove duplicates based on one column.
I have some work, in an Excel spreadsheet. Looking to combine multiple CSV files and filter based on keywords and remove duplicates based on a column. there are two similar csv file formats with one having extra column
...fulfilment, minor art manipulation in Illustrator, file folder creation and basic. The work will include the following: * eBay, WooCommerce e-commerce web-stores order fulfilment. * Retrieve data from eBay, WooCommerce incoming orders * Complete orders in fulfilment system (will be explained to the hired candidate) * Navigate dropbox file
...display some data from three tables (Tables 1, 2, 3) from an SQL server database. The tree tables are related to each other using foreign keys with a parent-child relationship. The treeview therefore has three levels of nodes. Expanding a treenode shows the child items under that node. If a user clicks on any of the nodes, the entire data set from that
...service it provides, and the regions/countries it is present in. A quadrant graph (updated with the information from the Excel worksheet) will be updated by placing (copying and pasting) the reduced version of the Logos obtained from the Internet (and names where these fit) of the AML/CTF consulting firms identified. Questions are welcome at anytime in the
...can be NO DELAYS between when the email comes in, and when you enter it onto form. There can also be NO ERRORS when entering in their first and last name, and copying and pasting the email and phone onto the form. No exceptions! There may be HOURS in between when emails come in....and in other cases, several emails can come all at once....so this
Seeking a Web Application Developer for a Part time or Full time project offer,all depend on the freelancers option, Individual should have an experience of at least 2 years in his/her skill, i'm seeking to establish a good relationship with my developer because the individual will start functioning as a staff of our organization, i'll need a very unique
...The job needs to be carried out roughly the same time each day. This is because the information you enter into the system will be processed and that takes about 24h. Then new data needs to be added. You should be keen to details and good and quick in communication. So if you can do the job about the same job each day you are a perfect fit for it.
in the Financial model as enclosed,I am not able to write a macro in this particular file, it says Compile Error. Syntax error. However I can write macros in a different excel file..not sure what is the problem in this file... Can you please help?? [removed by freelancer.com admin] Thanks
...contain various data - one sheet is a person's roster, another is an extract of their timesheet entries, another is employee data rules. I'm looking for a way to automate the reconciliation process for each employee (over 100) to check if the timesheet entries match the employees roster and advise me of any discrepancies. The data covers up to 2.5
NOTE: We only need the Excel with script to match the two excel matching the text Match text in two excel sheet and copy paste the row matching We will provide two excel sheet Compare SKU in 1st excel and match the Url with SKU in 2nd Excel Sheet Copy the Url row from 2nd Excel and paste in the image column of same SKU row
Looking at creating and automated excel file with VBA and macros for a certain task which would ultimately be automated, save to PDF and .Doc and also enter into another database which will be automatically formed. More details to follow
I have an application that automatically renames movie files and moves them to the correct folder. I need this application to run automaticall...the background whenever there is a change to a specific folder. There are a couple of buttons that need to be clicked automatically as well. I believe I could use a script or macros that can handle this task.
...Must have experience with coding macros in the Excel PERSONAL file. If you don't know what this means then please do not bid. I have an existing Macro. The function of the macro is to read a sales data file and insert the sales quantities into cells of MASTER file. Task: Extract an Order Number from the data file, and paste into into Row 5 Column
...publishing our library of adult videos from one clip site to another. Looking for someone to do this hourly. Must be fluent in English. Type of job: Admin/Data Entry Details: Copying and pasting relevant video information from one site to another. Videos are already uploaded, you just need to copy over the title, description, price, categories, save
...instructions on how I can merge the provided data on an excel spreadsheet into the text box of each page on the supplied InDesign file. I work on large catalogue projects that are fairly simple, image and style and description for each page and always supplied an excel spread sheet and want to get away from copying and pasting each page. As an example, page 2
Have many multiple excel files. Need macros that will take each main file and split into 100 items per file and save the file as csv Each file should have header labeled SKU and then underneath it should have 100 sku's. Each file should be saved as CSV. It should only take the items in the first column... Should be done in 24 hrs...
I have a table of data around 100M+ records with 50-60 columns. I am trying to show this data in datatable but unfortunately it is taking a lot of time to query pages with higher offsets. So, I want someone to provide a way to deal with this. So, any freelancer who is experienced with dealing with huge table of 400-500M of data. It should take only
Step 1: Need to remove "continue" button from checkout page and allow re...checkout page and allow redirect to the payment gateway after filling the checkout form instead of showing the information. (please check the screenshots) Step 2: Create macros of the products for custom emails. Step 3: Clear cart/session whenever we close and an open tab.