Em Andamento

Excel question

A very simple problem for an Excel guru. I would like to accomplish the following in an Excel spreadsheet using the Evaluate method.

I have a 3 column range expanding over 100 rows. I would like to take the value from column 1 and put it into some formula in Column 3 (same row) but rather than seeing the formula in the spreadsheet cell, I would like to "Evaluate" so that I only get the values in the cell and not the formula.

An example is Stock symbol and price.

All Stock symbols are in column 1 and I would like to use some stock function to bring in the price from some data source. I do not want to put the formula to do this in the 3rd column, instead I would like only the values to be shown based on the symbol in the corresponding 1st column.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

Excel, Windows

Habilidades: Engenharia, Microsoft, MySQL, PHP, Arquitetura de software, Teste de Software, Visual Basic, Área de trabalho do Windows

Ver mais: visual basic guru, row 44, guru symbols, guru method, basic guru, excel spreadsheet formula, visual basic form excel, excel guru, excel function, excel formula, excel row column, excel formula condition, excel based software, excel spreadsheet source code, excel column row, excel cell, stock spreadsheet excel, stock excel, install visual basic excel, excel stock symbol price, column row excel, source function excel, stock symbol, price formula, code excel spreadsheet

Acerca do Empregador:
( 20 comentários ) JerseyCity, United States

ID do Projeto: #2972895

Premiar a:

icodeinvb

See private message.

$7 USD em 1 dia
(316 Avaliações)
7.1

2 freelancers estão ofertando em média $6 para este trabalho

bodanb

See private message.

$4.25 USD em 1 dia
(3 Comentários)
0.0