EXCEL CONCATENATE/FORMULA/SCRIPT/MACRO Data manipulation 
We use EXCEL 2003. I think this task requires someone with a good knowledge of EXCEL formulae and probably...piece of text to the end of each title,
a maximum number of characters to be shown per title (any words...JOIN3..........JOIN4..........JOIN5 together
(Concatenate?) and insert a space in between each word. Any 
18 
Visual Basic, Data Processing, Excel, Microsoft 
Mar 11, 2010 
Mar 11, 2010Ended 
$72 
Data entry with Barcode Scanner Macro/Formula for Excel 
I need a Macro allowing us to record entries into a spread sheet via barcode reader. The 3 items are...are Sales Order Number which is 7 numbers, Part Number which can vary from 7 to 20 alpha numeric values...values, and a Serial Number that begins with a letter followed by 8 numbers. The goal is to have one spreadsheet 
6 
Data Entry, Excel 
Aug 19, 2013 
Aug 19, 2013Ended 
$80 



Data Processing, Data Entry, Accounting, Excel 
May 25, 2009 
May 25, 2009Ended 

Macro to concatenate fields into new worksheet 
Need a macro to concatenate ??" fields from one worksheet in to cell in another worksheet
Need master...cells from C3 on
Button Macro: Look for the Column header and concatenate Fields into “new worksheet...coder's Seller Legal Agreement).
## Platform
excel 2000 
4 
Anything Goes 
Sep 16, 2008 
Sep 16, 2008Ended 
$22 
Excel macro Formula 
...product code from data set. Need to build a macro or formula that will discover what other products were...were sold alongside it, (grouped by Sales Order Number), & by Customer.
Need to expand data each month...month, so will need to modify data and rerun macro / formula each month. Have attached example 
5 
Visual Basic, Excel 
Feb 19, 2015 
Feb 19, 2015Ended 
$79 
Excel Macro/Formula Expert 
...simple project for an expert in Excel Macros and Formulas. We have a number of csv files that we need to...really need someone who is an expert. This macro/formula must work for other csv files as well. The data 
4 
PHP, Engineering, Game Design, Software Architecture, Software Testing, MySQL 
Jan 5, 2007 
Jan 5, 2007Ended 
$23 
Excel formula 
Buyer needs a formula that evaluates a number of columns in the row to determine what it's value should...rules of the formula are listed below and should be evaluated in this order:
1) If cell P has a valid...valid date value make cell A say “Lucid ” + date value of cell P
2) If cell P does not have a valid date 
57 
Excel 
May 7, 2013 
May 7, 2013Ended 
 



Excel 
May 15, 2011 
May 15, 2011Ended 

formula to find text in Excel 
Hello,
I need a formula to find where text starts in Excel. THIS IS NOT to find specific text  it...[first part of the cell has spaces  anywhere from 1 space to 100 or more] so the cell would look like this:
...what the letter or number or special character will be. Maybe a way to do the formula it is to tell me 
6 
PHP, Visual Basic, Software Architecture, Microsoft 
Dec 25, 2013 
Dec 25, 2013Ended 
$23 
excel macro that executes a formula for values in a pivot table 
I am looking for an macro that calculates an index = 1 minus the Herfindahl Index for companies listed...you could e.g. compute intermediate steps of the formula in the columns next to the pivot table.
How...class
H = sum of square(number of products in class i and year j/total number of products in year j) for 
12 
Visual Basic, Data Processing, Excel 
Jan 29, 2014 
Jan 29, 2014Ended 
$34 
concatenate excel cels, using VBA 
...the column B it's the number of lines for the same Report ID, generated by a formula (countif)
 in the...column C it's the number of line where it starts that Report ID,
also generated by a formula;
 in the column...column D it's the number of line where it ends that Report ID;
also generated by a formula;
what I need 
1 
Visual Basic, Microsoft Access, Visual Foxpro, , Visual Basic for Apps, Windows API 
Feb 18, 2015 
Feb 18, 2015Ended 
$39 
Excel Formula 
Require an excel formula created to calculator living expenses.
e.g.
Number of Adults = > Input...Input number
Number of Children = > Input number
Table:
1 Adult 0 Children = 1000
1 Adult 1 Children...will be able to enter a number in (Adult) cell 1 or (Adult) cell 2 and the formula will search for the correct 
37 
Excel 
Jan 23, 2014 
Jan 23, 2014Ended 
$19 
VB Macro OR formula for excel sheet. 
I have excel with multiple tabs. I need a button that will generate report pulling information from multiple...tabs. Tabs could be added removed and renamed. So formula/algorithm should be able to pick this up.
Report...report. Cell colors should be reflected in the report as well.
In addition i have one formula that needs 
41 
Visual Basic, Excel 
Feb 15, 2015 
Feb 15, 2015Ended 
$27 
concatenate csv files and adjust existing macro  repost 
...have an excel macro that just needs a little adjusting. We need to be able to import any number of csv...that the current macro runs on. Then there are just a few adjustments needed to the macro, filtering and...
Needs done asap.
Please note this is for Excel 2011 Mac, so reference to Microsoft Scripting Runtime 
10 
Excel, Mac OS 
Mar 11, 2013 
Mar 11, 2013Ended 
$109 
Excel Expert needed for macro or formula 
I have an excel spreadsheet that is pulled from an external data source. I need to make a simple calculation...with the minus sign on the "wrong" side of the number. I need to be able to identify those numbers as 
15 
Excel 
Dec 8, 2011 
Dec 8, 2011Ended 
$32 
416689 Fast Simple Excel formula 
Please feel free to usewhatever functions,IF or Macro. I need this as soon as possible so I will take...to complete.
Simple excel formula, macro or procedure to help assign "number" (column D) to each new...should enter Proc as shown.
b)For each new part number added into the list, it is classified by assigning 
1 
Excel, Anything Goes 
May 26, 2010 
May 26, 2010Ended 
$10 
EXCEL IF formula 
I have an Excel spreadsheet that downloads stock market data every day and calculates the range that...that the stock market will stay in over x number of days, ONLY when certain IF criteria are met. If they...current criteria, I want Excel to look back over the specified number of days (cell P2 in the spreadsheet) 
4 
PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL 
Apr 23, 2009 
Apr 23, 2009Ended 
$29 
excel macro that executes a formula for values in a pivot table  repost 
I am looking for an macro that calculates an index = 1 minus the Herfindahl Index for companies listed...you could e.g. compute intermediate steps of the formula in the columns next to the pivot table.
How...class
H = sum of square(number of products in class i and year j/total number of products in year j) for 
4 
Visual Basic, Data Processing, Excel 
Jan 30, 2014 
Jan 30, 2014Ended 
$7 
concatenate csv files and adjust existing macro 
...have an excel macro that just needs a little adjusting. We need to be able to import any number of csv...that the current macro runs on. Then there are just a few adjustments needed to the macro, filtering and 
2 
Excel, Mac OS 
Mar 10, 2013 
Mar 10, 2013Ended 
$92 
Excel Macro to Concatenate Columns Automatically 
I need a macro that will concatonate two columns of words for me in excel. This should be quite simple 
12 
Anything Goes 
Mar 30, 2011 
Mar 30, 2011Ended 
$13 
VBA, MACRO, and EXCEL Work  Concatenate .PDF's with Macro 
I need a Macro edited for file making in Excel:
Existing document with most of the code complete 
3 
Visual Basic, Excel 
Jun 29, 2012 
Jun 29, 2012Ended 
$38 
VBA macro for Excel 
VBA Macro on Excel
I will describe what the macro will do through the Excel Macro_VBA_project.xls...» would mean 14h56 and 39 seconds.
The Macro will ‘create’ 12 new columns, from AZ to BK with...folling order and titles (to be written in the first cell of each column): CS cumul, CT cumul, SV5 cumul, 
29 
Visual Basic, Microsoft 
Jan 21, 2010 
Jan 21, 2010Ended 
$310 
Excel 2010 resources  Formula (not macro) driven  2 
...needs to be turned around in 15 hrs.
HAVE A excel 2010 spreadsheet with 3 tabs.
The spreadsheet allocates...date)
In this sample sheet I will send you  Every cell highlighted in Yellow means this is a answer that...that should come up in search results or with a formula
Row JM WILL show results for the above.
=== 
7 
Visual Basic, Excel 
Jul 14, 2014 
Jul 14, 2014Ended 
$28 
Excel 2010 resources  Formula (not macro) driven 
...small, quick and simple job this time:
HAVE A excel 2010 spreadsheet with 3 tabs.
The spreadsheet allocates... task or skill ( you can chose multiple)
Every cell highlighted in Yellow means this is a answer that...that should come up in search results or with a formula
Row JM WILL show results for the above.
=== 
15 
Excel 
Jul 10, 2014 
Jul 10, 2014Ended 
$39 
Excel Formula & Macro 
...this on each monthly worksheet there needs to be a macro button 'Output Tenon Summary' which copies the relevant 
11 
PHP, Engineering, Software Architecture, Software Testing, MySQL, Anything Goes 
Mar 29, 2010 
Mar 29, 2010Ended 
$39 
Excel Formula  repost 
Require an excel formula created to calculator living expenses.
e.g.
Number of Adults = > Input...Input number
Number of Children = > Input number
Table:
1 Adult 0 Children = 1000
1 Adult 1 Children...will be able to enter a number in (Adult) cell 1 or (Adult) cell 2 and the formula will search for the correct 
1 
Data Entry, Excel 
Mar 19, 2014 
Mar 19, 2014Ended 
$22 
Excel 2010 resources  Formula (not macro) driven 
...needs to be turned around in 15 hrs.
HAVE A excel 2010 spreadsheet with 3 tabs.
The spreadsheet allocates...date)
In this sample sheet I will send you  Every cell highlighted in Yellow means this is a answer that...that should come up in search results or with a formula
Row JM WILL show results for the above.
=== 
11 
Excel 
Jul 14, 2014 
Jul 14, 2014Ended 
$32 
Excel 2010 resources  Formula (not macro) driven 
...needs to be turned around in 15 hrs.
HAVE A excel 2010 spreadsheet with 3 tabs.
The spreadsheet allocates...date)
In this sample sheet I will send you  Every cell highlighted in Yellow means this is a answer that...that should come up in search results or with a formula
Row JM WILL show results for the above.
=== 
6 
Excel 
Jul 14, 2014 
Jul 14, 2014Ended 
$30 
Excel Formula  repost 
Require an excel formula created to calculator living expenses.
e.g.
Number of Adults = > Input...Input number
Number of Children = > Input number
Table:
1 Adult 0 Children = 1000
1 Adult 1 Children...will be able to enter a number in (Adult) cell 1 or (Adult) cell 2 and the formula will search for the correct 
31 
Excel 
Jan 23, 2014 
Jan 23, 2014Ended 
$16 
Excel formula and Macro Sheet. 
...file with macro's and formula's.
Its is basic excel file to keep track of inventory and purchase status 
15 
Visual Basic, Data Processing, Data Entry, Excel, Data Mining 
Sep 21, 2012 
Sep 21, 2012Ended 
$98 
Excel 2010 resources  Formula (not macro) driven 
...needs to be turned around in 15 hrs.
HAVE A excel 2010 spreadsheet with 3 tabs.
The spreadsheet allocates...date)
In this sample sheet I will send you  Every cell highlighted in Yellow means this is a answer that...that should come up in search results or with a formula
Row JM WILL show results for the above.
=== 
5 
Excel 
Jul 14, 2014 
Jul 14, 2014Ended 
$29 
Excel Macro or Formula 
Please see the attached Excel spreadsheet. I need a macro or formula to take the Input and give the 
14 
Data Processing, Excel 
Jul 23, 2013 
Jul 23, 2013Ended 
$23 
Excel Macro formula design or data entry 
I have an excel spreadsheet from a supplier that I need an easy way of importing into my MySQL database...interface for someone, but I would prefer an Excel macro to automate the process in the future.?
##...## Deliverables
You will be provided with an Excel spreadsheet from a supplier.? The size/color is currently 
8 
PHP, Project Management, Data Entry, Engineering, Software Architecture, Software Testing, MySQL 
Jan 21, 2009 
Jan 21, 2009Ended 
$333 
412106 Excel macro or formula 
This is a followup excel project dealing with macros and formulas. Will give descriptions to provider

1 
Excel, Anything Goes 
May 6, 2010 
May 6, 2010Ended 
$15 
Excel formula or macro 
...
How can I automatize, with 7 formulas or a macro, those 7 field in line 10 so that only the data 
29 
Excel, Visual Basic for Apps 
Feb 11, 2014 
Feb 11, 2014Ended 
$24 
Write macro / formula for excel 
For a import of a webshop I need to have a Macro / formula written. What is the case: In our export all...write me a macro / formula that does this into our attachment:
* Use the text together formula (T2;"";T3;"";T4)...(T2;"";T3;"";T4)
* Make sure this formula will only be displayed at the first line of a... 
20 
Excel 
Jun 17, 2014 
Jun 17, 2014Ended 
$35 
Excel Macro 
I need an excel guru to design a macro, for a voucher system for a health spa.
The system will need...automatically increase each voucher number.
We need to able to add number vouchers and maybe a name and dollar...ask for a name both first and last name, phone number (both are compulsory fields) and email address 
2 
Windows Desktop, Project Management, Engineering, Software Architecture, Software Testing, Microsoft 
Dec 7, 2010 
Dec 7, 2010Ended 
$53 
Looking for Macro/Formula for Excel 
...for some one Expert in Excel, writing Macros or any Formula..I need some excel knowledge(macros or something 
7 
Data Processing, Data Entry, Excel 
Nov 26, 2013 
Nov 26, 2013Ended 
$18 
Simple Excel Formula or Macro 
I have attached the details of the project.
Search down one column and get a result based on matching to another column. 
26 
Excel 
Dec 6, 2012 
Dec 6, 2012Ended 
$30 
Help with excel formula 
...help with this Excel formula......I need it to return zero into cell C2 if the number in B2 is less than 
1 
Excel, 
Aug 31, 2014 
Aug 31, 2014Ended 
$20 
Excel Macro to increment a number by 1 needed 
...a MSExcel spreadsheet so that each time I click to open a new SHEET, a specific cell, i.e. cell A1 has...has a number in it which is 1 greater than the number on its parent sheet. i.e. Sheet1 in Cell A1 there...there should be a number 1. When I go to Sheet 2, Cell A1 in Sheet 2 should say 2. I want all numbers so 
10 
Project Management, Engineering, Software Architecture, Software Testing, Website Testing, Website Management, Web Hosting 
Jul 8, 2011 
Jul 8, 2011Ended 
$3 
Excel Macro 
For MS EXCEL we need a seperate application or a macro written that can output a line of text to a specified...text will be triggered when a value in a specified cell is changed (to a specified new value such as from...will be no worksheet event at all ( the formula in the cell will use a dde link to an external data source 
21 
PHP, Visual Basic, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL 
Apr 21, 2006 
Apr 21, 2006Ended 
$125 
Macro to evaluate number, create new cells and verify formula 
I have an Excel file that contains transactions from two different systems (left and right). Both systems...the right hand side only (K through O).
The macro should start at a given row that the user should... and before each row check, the macro should ensure that the formula in H & J is correct for the row 
1 
Data Processing, Excel, Visual Basic for Apps 
Feb 2, 2014 
Feb 2, 2014Ended 
$25 
MS Excel formula project 
I need an interactive formula written for me in MS Excel.
Objective: What I'm trying to do is cut...in a cell to a specific length without chopping a word in half. If there isn't any text in the cell then...done.
1. Look at a specific cell.
2. Is there text in the cell?
No  Enter predefined text. 
18 
PHP, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL 
Aug 10, 2004 
Aug 10, 2004Ended 
$18 
Excel Formula to Separate One Cell components to Multiple Cells 
I need a formula or a macro that can copy specific column A data into Column B, C and D
Please check 
7 
Visual Basic, Excel 
Nov 11, 2013 
Nov 11, 2013Ended 
 
Excel Macro 
Write Excel macro for a spreadsheet we will provide to work out the last row of data in a number of tabs...numbers that are after the colon (ie. The end row/cell reference of the array).
3. Reset All rows in "Forecast...product description.
Table B9:AE24 must be pasted in cell underneath product description.
4. Sort "Incoming 
18 
Visual Basic, Excel 
Aug 27, 2014 
Aug 27, 2014Ended 
 
258350 Quick Excel Formula 
This should be a quick job for someone who knows Excel well.
So I'd like to do the following without...idea or two:
The Problem:
In cell A1, I have a positive number, let's say 6. In cells A2:T2, I have...series of numbers. I'd like to write a formula residing in each cell of row 3 that sums up the values of 
0 
Visual Basic, Anything Goes 
Oct 13, 2008 
Oct 13, 2008Ended 
 
Excel Macro 
I copy and paste into Excel but the numbers are being registered as text.I would like the numbers converted...converted so that Excel recognizes them as numbers, and i can use mathematical equations on them.I race... each column number up into two columns. I would like to make one column for the number(s) before the 
32 
Excel 
Oct 19, 2013 
Oct 19, 2013Ended 
$296 
Excel Macro to place information in a certain cell 
...exported from our ecommerce system: The order number is in column A.
Orders may consist of a single...item (item = product) or mulitple items.
The number in column AL tells how many items are in the order...presently identical: The number of rows per order always matches the number of items in the order.

11 
Visual Basic, Excel 
Nov 16, 2014 
Nov 16, 2014Ended 
$34 
Excel Macro Bin# return 
...extract bin# value and if not found then an empty cell must be displayed.
If there are 2 bin#'s are...the maximum)
If no bin# is found then an empty cell must be displayed!
I tried to fix the issue...column " My formula 1 " + " My formula 2 "
I prefer if it could be written all in one cell if possible 
5 
PHP, Visual Basic, Software Architecture 
Aug 2, 2013 
Aug 2, 2013Ended 
$16 