Get a Freelance Job

Hi,

I need to make an excel template file work in openoffice (I don’t have excel). It is to upload an address list to a website. (I have been provided this template, but can’t get it to work) but if you can make a compatible version of the document it should work (it contains macros). I keep getting an error of “missing delivery name” or “phone number is too long” – even though the delivery name is entered, and the phone number is within allowable limits. Thanks, Michelle

Ability to move an entire row in Excel from one worksheet to adjoining (open to paid) via a based on condition (date format) being present in a specific column.

Would prefer the ability to enter all check number and dates first and then have a button that moves all rows (cut, paste, delete empty) with check information into the adjoining worksheet.

Thank you.

I have 2000 records in excel that I need to divide them to several cells (columns)

I have 2 lists of prouducts. Each products have 5 parameters: Id,name,code, city and “city or state”. one list don`t have IDs.
I need to match between products with ID and without ID and add the Id. some of the names are a little bit different betwenn the two lists.

I will choose someone not expensive only if he can do it Full Time for few days.

I have a requirement to merge a number of rows from multiple excel worksheets in to a consolidated summary sheet. This is not a one-off project i.e. The macro will be run on a weekly basis against the same worksheet names, etc. to produce a weekly status report.

I have enclosed an example of the workbook and worksheets.

Project (In Blue) is the top level sort and will be sorted on ‘Start Date’

Milestone (In Green) is the second level sort and will be sorted on ‘Due Date’ NB. Note the Pr…

I have 2 lists of prouducts. Each products have 5 parameters: Id,name,code, city and “city or state”. one list don`t have IDs.
I need to match between products with ID and without ID and add the Id. some of the names are a little bit different betwenn the two lists.

I have around 9,900 records without Id that needed to be completed.
I will choose someone not expensive that can do it Full Time for few days.

I have 2 lists of prouducts. Each products have 5 parameters: Id,name,code, city and “city or state”. one list don`t have IDs.
I need to match between products with ID and without ID and add the Id. some of the names are a little bit different betwenn the two lists.

I add a sample of the list concept, I have around 9,900 records without Id that needed to be completed.

I will choose someone not expensive that can do it Full Time for few days.

This is a simple copy and paste project. I have an excel file which has about 10,000 columns and about 10 rows. I need someone to copy and paste words into 5 rows of every column. You will copy and paste from the title which has about 5-12 words. You will copy two words from the titel to form keywords on 5 rows from every column. It is very simple just takes a bit of time to copy and paste.

We have a small VBA function that inserts an image into an Excel 2010 worksheet. This function contains three options (file path, width, height). This function updates the image any time anything is changed with the formula that calls the function and deletes the previous old picture.

We would like to add a few features to this existing VBA function

Correlation and Regression

First let me say I have only limited knowledge of statistics and no knowledge of using Excel for correlation and regression. Therefore what follows may or may not make sense and I expect you to tell me the best way I can use the data to be able to predict the likely outcome of, for example, a tennis match.

Here’s what I’ve done
From past results for each winner of a tennis match I have collected together some of the independent variables (X1 X2 X3 X4) that I th…

I have an excel table that has a column in it that has a time value, for instance 1/1/2012 12:09:16PM, the next row has a value in it such as 1/1/2012 1:03:12PM, etc. There are roughly 7502 rows one column. I need a bar chart or pie chart that shows an average of how many times each hour something shows. These times are alerts that are logged and I need to know when the majority of alerts come in (Percentage Value). For instance, at 3:00 PM 12%. So the chart can be a bar chart, pie chart e…

I’ve written many VBA macros in Microsoft excel (2003 & 2007). Now i need a working document (tutorial) to show me how to put VBA macro codes into the Graphic Ribbon Designer in Visual Studio 10. The documentation should also include techniques I’ll be able to use in distribute the final ribbons (via xlam or other secure formats). The documentation should be graphic (screenshot/picture) intensive.
I’m looking for someone who i can work with long term after this project because there are many VB…

Need a script that will print an Excel workbook to PDF automatically, without any user input, and save it to a specified folder on the desktop. Need the script to do this at 7am an 12 pm PST (but if you give me the script, I can probably set this up as a scheduled task in Windows).

The workbook contains cells which constantly update from an outside data source, so saving the spreadsheet as an Excel doc is not an option, seems it must be printed to PDF.

The end product will be a script whe…

I want someone who can do a daily job that may take two hours.
The job would be to look and compare data in the web.

I would like to receive a monthly offer.

If you have a macro such as QI Macros which runs on Excel this will be a simple project.

I will provide the details of the project with those that have relevant experience and are interested. However, you can place a bid either before or after that dicussion

Basically, you will be working with an exported excel spreadsheet with multiple columns one of which will be the desired outcome and the other columns are the variables that affect the outcome. I want to know which are the most signifi…

Hi,

i’m looking for someone, who just have to find the website and location (city/state and country) of financial firms, that are given in an excel table.

The results should be reliable and entered in the same table. There are about 1200-1300 records.

Thank you very much

I need the information from the tab “By Area” transcribed to an excel spreadsheet.

Website is here http://tinyurl.com/799vvfm

Please quote price & time required.

The enclosed PDF document contains several tables of data, which I need accurately converted to an Excel document.

Tables of data are available in pages 9,10,11,12,13 and 14

Tables 1 and 2 in each of these pages need to be merged together. Same for tables 3 and 4. How? Just by Putting table 2 to the right of table 1, and table 4 to the right of table 3.

This is because these tables represent prices per height (in rows) and widths (columns). Tables 2 and 4 contain widths that complement…

I repeatedly visit clients and gather survey data in the form of questions answered with a 1 to 5 rating. I’m currently creating graphs from this data in a very manual fashion because I’m not an Excel expert. I want someone to create a spreadsheet that automatically creates a graph for each code after I enter the data. I also want this graph to update in a corresponding MS Powerpoint file for each code.

I am interested in American Baseball and I want to be able to do the following:

1) Download players current statistical data from http://espn.go.com/mlb/stats/pitching/_/year/2011/seasontype/2 to an Excel spreadsheet .
Note – this shows the data for the whole 2011 bseball season which has concluded but when the season starts again around April 2012 it will display a summary of that season to date

2) In the Excel display I want all columns removed EXCEPT those headed RK, PLayer, IP, R, ER…

I need 200 addresses and phone numbers copied and pasted from a word document to an excel spread sheet. This is a simple copy and paste job. There may be a few entries without a zip cod which may need to be looked up.

The format varies slightly so using a script probably will not work but it is easy for a human.

The excel format will be

Business Address Zip Code PhoneNumber Source Rank Professionals

The word format is:

…
Business Name
Address
City, State Zip Code
Phone Numbe…

I need 200 addresses and phone numbers copied and pasted from a word document to an excel spread sheet. This is a simple copy and paste job. There may be a few entries without a zip cod which may need to be looked up.

The format varies slightly so using a script probably will not work but it is easy for a human.

The excel format will be

Business Address Zip Code PhoneNumber Source Rank Professionals

The word format is:

Business Name
Address
City, State Zip Code
Phone Number
Nu…

I need 200 addresses and phone numbers copied and pasted from a word document to an excel spread sheet. This is a simple copy and paste job. There may be a few entries without a zip cod which may need to be looked up.

The format varies slightly so using a script probably will not work but it is easy for a human.

The excel format will be

Business Address Zip Code PhoneNumber Source Rank Professionals

The word format is:

Business Name
Address
City, State Zip Code
Phone Number
Nu…

Alright– I know one of you can do this quick!
I need a “phone book” or data intake sheet that looks like an address book.

I have attached a sample of what fields I need to be included.

I need to be able to keep an index as each record is added.
Each record added should have its own page or intake sheet.

I need to be able to view ALL records one a single page.
I should be able to choose one of those records that will take me to the full page for that record.

The number of fields …

I need an accurate and fast data entry professional to put together a Spreadsheet for me.

I have several PDF text of data that I need inputted into excel so I can use and analyze the information.

you have to type that data in a Excel Spreadsheet Grid Box.

This is a tedious yet easy job.

You must work on a regular basis.

The information will be sent via PM as a PDF text and I want the information to be input into an Excel grid.

Project Requirements:

1. New Contractors will …

I need an Excel Macro written. All of the details are written inside the attached spreadsheet.

Hi there before I order I was wondering if anyone could help me out:

See my issue is my co worker wants me to help her with her excel spreadsheets but to be honest I have no idea about how to go about doing anything on excel. I really need someone to help me with the specifications that i will detail below so that I could impress my co worker.

Here is what they wanted:

- What we need is an Occupancy Forecast tracking spreadsheet. Everyday we want to keep track of our occupancy …

I have a data entry / OCR project with the information to be recorded into an excel spreadsheet.

Please see example spreadsheet for details

I look forward to you best bids for a simple project

Kind regards

Chris M

See attached spreadsheet for instructions.

I need an accurate and fast data entry professional to put together a Spreadsheet for me.

I have several PDF text of data that I need inputted into excel so I can use and analyze the information.

you have to type that data in a Excel Spreadsheet Grid Box.

This is a tedious yet easy job.

You must work on a regular basis.

The information will be sent via PM as a PDF text and I want the information to be input into an Excel grid.

Project Requirements:

1. New Contractors will …

I have an excel list that contains a list of 500 web sites. I need the following done.

1. check each web site to confirm that the site is active
2. Check the list to insure that there are no duplicates on the list
4. Send me the final list of only the companies that are still active as a word doc (not excel) with the company name and the web site address under the companies name.

I will provide the web site addresses where the companies on the list were obtained so that the successful b…

Excel VBA Tutorial’s

In need of a talented person to write two professional VBA Microsoft Excel 2010 tutorials. The tutorial’s will need to contain step by step instructions. Please only bid if you are serious and actually know Excel VBA.

Topics:

Basic behind a Macro
Explain Macro Editor

The tutorials needs to be unique as well.

I need an XSL style sheet to transpose data in XML format into a pre-defined Excel workbook with multiple sheets. I will use the XSL style sheet while exporting data from one piece of inventory control software in preparation for importing into the new software. The XSL style sheet must result in a completely usable Excel workbook with sheets and fields which are already defined. The style sheet will transpose one inventory record at a time.

I have attached a sample XML file and a sample Exc…

I am looking for someone to write 1-2 Excel related tutorials per month. Each tutorial will need to be 50-250 words depending on the complexity. All tutorials will be written using WordPress. Each tutorial will also need to be unique.

Sample Topics:
Excel VBA – Requested
Excel 2010
Access 2010

This is an on going job. I’m looking to pay $5 USD per tutorial.

If you have any questions, please ask.

We are looking for an individual or company experienced in X-Cart Excel data feed work. Project is for 50 Excel spreadsheet rows.

Payment is to be made only after successful data feed upload.

Please bid if you have experience with these data feeds. We are ready to assist as needed but we are not willing to provide any extensive training.

Rows must be checked for errors before returning to us. Some columns, especially CATEGORY, will need to be intelligently selected.

Complete X-Cart i…

Hello,

I have created an excel simulator (to calculate profit, expenses, etc for a bar), you can have an idea here:
http://dl.dropbox.com/u/1993029/example.png

I haven’t discovered or have done a huge thing (it’s just simple formulas) but i lost 20hours doing this excel and i want to protect him.

He will be shared between my workers (so they can use the simulator), and i really want to have it protected, so please give me your best solutions:

1. turn the excel into a protected excel…

We have csv files from our database that we have found asins for and all required fields are filled out but are not able to upload to Amazon for some reason. Possibly a template issue and may need a re-write for our template. Approximately 7500 SKUs in groups of 50 to 500 per spreadsheet.
We also have excel files that I am receiving from manufacturers from their ftp that we would like to bulk upload to Amazon. They do not have ASIN numbers. I have item #/manufacturer/title/descriptions, some …

I have an Excel file that I need cleaned up with a script or macro. There are 22,000 rows so I don’t have time for a manual project.

I’ve attached a sample that shows the issues:

1. ALL CAPS fixed. CHILDRENS FUND = Childrens Fund, etc. all cells

2. On some rows the data is in the wrong cell. When done I want only these columns:

Company
Name
Address 1
Address 2
City
State
Zip
Phone
Title

So for instance data that is in Phone 2 must be moved to Phone 1, data in State 2 move…

Hello Bidder,

We need Excel base small module. We are book publisher so we need advance formulas creator and experienced person in excel.

We want to manage following things

- Production price of book with some basic imputes
- Production Planning Flow chart date wise
- List of vendor and automated PO generation with unique PO No.
- We want list of bills and all new Po’s must added in list of billing.
- Billing Tracking like bill received, send to accounts for chq, bill paid

I…

Need following general specs for a pairs trading excel(and/or google docs sheet):

Excel spreadsheet with data feed from Interactive Brokers and from Google Finance (maybe a button to chose which one to use. Even better if spreadsheet could also be converted into google docs and receive same data feeds as for excel).

Ability to download interval price records from IB or Google finance (60 minutes for sake of argument, must be able to specify any time frames, including daily, weekly etc). s…