Em Andamento

VBA to add comments automatically to Excel spreadsheet

Here is a description of the project I need to complete. I have an Excel spreadsheet where I need to automatically populate the comments field for specific cells with data from a lookup. The lookup data resides in the same spreadsheet, but in a different worksheet. There is a worksheet in the (attached to this project) XLS entitled "Values". There is a list of items in a column called "Value Number". What I need to do is lookup the corresponding Value Number in the "Lookup Table" worksheet, take the Text1, Text2, Text3, Text4, Text5, and Text6 columns associated with that Value Number and add them as a comment to the original Value Number cell on the "Values" worksheet, and highlight (bold) the Text1, Text3, and Text5 columns in the resulting comment. This needs to happen for each Value Number listed. You can have this script invoked when opening the XLS, or you can put a push button on the worksheet to invoke the script. I am also open to other ideas on how best to run the script to add the comments.

## Deliverables

1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).

## Platform

Microsoft Excel - Windows

Habilidades: Excel, Microsoft Access, Microsoft Exchange, Powerpoint, Instalação de Script, Shell Script, Arquitetura de software, Área de trabalho do Windows, Word

Ver mais: vba work, vba with, spreadsheet script, microsoft excel spreadsheet, excel 16, what is vba in excel, what is vba, microsoft vba, microsoft excel VBA, how to microsoft excel, how to hire a worker, excel party hire, excel for hire, spreadsheet microsoft excel, project on vba, list to excel, how to add a button, Hire Excel, excel vba script, automatically, excel data table lookup, windows vba, populate excel spreadsheet spreadsheet, opening vba, opening vba project

Acerca do Empregador:
( 2 comentários ) United States

ID do Projeto: #2988092

Premiar a:

sqlvba

See private message.

$5 USD em 14 dias
(9 Avaliações)
1.5

18 freelancers estão ofertando em média $20 para este trabalho

gribfritz

See private message.

$21.25 USD in 14 dias
(485 Comentários)
7.6
dominique1

See private message.

$21.25 USD in 14 dias
(298 Comentários)
6.3
sergeyzhebka

See private message.

$17 USD in 14 dias
(183 Comentários)
6.3
tusharjohri

See private message.

$12.74 USD in 14 dias
(75 Comentários)
5.5
Lotusdeveloper

See private message.

$29.75 USD in 14 dias
(85 Comentários)
5.2
ricks7

See private message.

$46.75 USD in 14 dias
(87 Comentários)
5.2
syedmahtab

See private message.

$21.25 USD in 14 dias
(36 Comentários)
4.7
ramanujana

See private message.

$16.15 USD in 14 dias
(34 Comentários)
4.4
powzak

See private message.

$25.5 USD in 14 dias
(28 Comentários)
4.1
iqmax99

See private message.

$12.75 USD in 14 dias
(51 Comentários)
4.1
tannic

See private message.

$68 USD in 14 dias
(10 Comentários)
3.7
ieinfotech

See private message.

$16.15 USD in 14 dias
(17 Comentários)
3.4
joshuafalkenvw

See private message.

$12.75 USD in 14 dias
(2 Comentários)
2.8
d2bsolutions

See private message.

$12.75 USD in 14 dias
(10 Comentários)
2.3
TushVaid

See private message.

$12.75 USD in 14 dias
(4 Comentários)
1.6
barasztamas

See private message.

$46.75 USD in 14 dias
(0 Comentários)
0.0
sergeberg

See private message.

$17 USD in 14 dias
(0 Comentários)
0.0
soulmind22

See private message.

$17 USD in 14 dias
(1 Comentário)
0.0