Em Andamento

Excel Visual Basic or Macro

I am an investment advisor and each quarter I need to check client accounts and make sure that the percentage of an investment account in a particular investment is within permitted bounds.

? Data comes in a worksheet in one format.? I need pulled across to a second worksheet.? I cannot use Excel formula to pull data (e.g. vlookup function) as depending on the data in the source different courses of action will be needed.

specific requirements can be provided.? I would imagine visual basic would be needed.

?

## Deliverables

I am an investment advisor and each quarter I need to check client accounts and make sure that the percentage of an investment account in a particular investment is within permitted bounds.

Data comes in a worksheet in one format. I need pulled across to a second worksheet. I cannot use Excel formula to pull data (e.g. vlookup function) as depending on the data in the source different courses of action will be needed.

I receive data for each account in an Excel worksheet (Source [url removed, login to view]) with the columns: Account Number, account name, ticker symbol or CUSIP (This is a unique five to eight character identifier of an investment), security name and current value. E.g.

Account Number Account name? ? ? ? ? ticker security name? ? ? ? ? ? ? ? ? Value

71667011? ? ? ? ? ? ? ? ? Joe Peterson IRA AVVXX Aim Constellation? ? ? ? ? $13,000

I have a second worksheet (Master Client Asset Allocation [url removed, login to view]) which needs to pull data across form the first worksheet. The second worksheet contains dozens of tables. One table per account number. Each table looks like this:

71667011 Joe Peterson IRA

AVVXX AIM Constellation $13,000

MCMXX Putnam Growth $24,000

8051608 Bank of America 6 month CD $12,333.32

etc.

I need a program that I can activate from Master Client Asset Allocation [url removed, login to view] which will open Source [url removed, login to view] (which will be in the same directory) and then will do the following:

1. Each security value in Master worksheet is set to zero.

2. Use the ticker symbol on the Master worksheet to index into Source Data and pull across all current values.

3. If there is a ticker symbol on Source [url removed, login to view] that does not exist on Master Client Asset Allocation [url removed, login to view], the program inserts a row in the account's table after the first line of existing data by copying the first line of existing data, and then overwriting the ticker, security name and value. This new position is flagged by entering an asterisk in column one of the Master worksheet.

4. Then an error checking mechanism runs by totalling the amount in each account in Source [url removed, login to view] and compares it to the total amount in each account in Master worksheet. If there is an error that should be flagged in column two by a “**??

5. A second error checking routine runs which checks to see if there is an account number in the Source Data worksheet that is not on the master worksheet. If so, the missing account number and name should be written to the second tab of the Master worksheet.

Habilidades: Engenharia, Microsoft, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Área de trabalho do Windows

Ver mais: ticker line, tab bank, security first bank, open source visual basic 6, master security, first source bank, america's line, vlookup table, joe g, bank account name, open a bank account on line, on line bank accounts, master excel, basic needs of accounts, bank account on line, Vlookup, visual basic form excel, Visual Basic Excel, Visual Basic 6, s joe, macro e, imagine form, excel vlookup, excel visual basic, excel function

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

ID do Projeto: #3005445

Premiar a:

abcdefghivw

See private message.

$85 USD em 14 dias
(6 Avaliações)
4.3

23 freelancers estão ofertando em média $143 para este trabalho

TheoYZ

See private message.

$212.5 USD in 14 dias
(174 Comentários)
7.7
hwanghendra

See private message.

$127.08 USD in 14 dias
(416 Comentários)
6.8
schandraram

See private message.

$170 USD in 14 dias
(149 Comentários)
6.8
suthernsoftware

See private message.

$212.5 USD in 14 dias
(60 Comentários)
6.6
jawadh

See private message.

$106.25 USD in 14 dias
(83 Comentários)
6.0
deepbluetech

See private message.

$127.5 USD in 14 dias
(133 Comentários)
5.3
greengrasss

See private message.

$127.5 USD in 14 dias
(11 Comentários)
4.9
azrajobs

See private message.

$131.75 USD in 14 dias
(44 Comentários)
4.9
felixrii

See private message.

$212.5 USD in 14 dias
(19 Comentários)
4.8
excelsolution

See private message.

$97.75 USD in 14 dias
(58 Comentários)
4.7
notvalidalv

See private message.

$123.25 USD in 14 dias
(41 Comentários)
4.6
farooqgill

See private message.

$127.5 USD in 14 dias
(15 Comentários)
4.6
nikitasvw

See private message.

$85 USD in 14 dias
(66 Comentários)
4.3
SHhadun

See private message.

$102 USD in 14 dias
(22 Comentários)
3.8
schoolofadv

See private message.

$255 USD in 14 dias
(11 Comentários)
3.7
YuriyShevtsov

See private message.

$102 USD in 14 dias
(5 Comentários)
3.6
vw6937213vw

See private message.

$102 USD in 14 dias
(9 Comentários)
2.2
ravindra2vw

See private message.

$170 USD in 14 dias
(1 Comentário)
1.4
ivyleaguegurus

See private message.

$170 USD in 14 dias
(0 Comentários)
0.0
exitplz

See private message.

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