Em Andamento

VBA / Excel project

We currently use an Excel workbook to collect data from a number of web sources, on approximately 80 worksheets. We then use a macro to sort, filter and organise this data, and output relevant information on a further output sheet, where it is saved as a CSV file for use in a database.

We need some functionality adding to this pre-existing macro, or possibly a new macro written to add this functionality.

## Deliverables

The macro needs to do the following:

1. Add a priority flag (a number 1-5) to each line entry in the output sheet. This is taken from the source sheet - each source sheet will have its own priority, and this number will be added to each line entry originating from that sheet.

2. Filter the output sheet by date. We would like to enter to- and from- fields, and all line entries later or earlier than these dates will be deleted from the output sheet.

3. Delete rows based on a number of text strings. We need to be able to specify a number of text strings - for example, "Johnson", "Smith" and "Jones". The macro needs to check if any of these strings appear in a sepcific field of each line entry on the output sheet. If a string appears, even with additional characters, then the line entry needs to be deleted.

Please email and I will be able to forward a copy of the existing file, as it stands - this may make our requirements clearer!

Habilidades:

Ver mais: vba with, vba excel macro, sort excel, macro vba, johnson, excel vba script, excel macro vba, project database vba excel, vba excel copy, excel macro sort, csv script vba, excel sort date, sort macro, filter vba, macro script file, excel macro add, vba filter, excel 2011 vba, excel project use database, excel add strings, excel macro csv, excel macro delete text, excel copy vba macro, excel additional, sort excel date

Acerca do Empregador:
( 32 comentários ) United Kingdom

ID do Projeto: #3024021

Premiar a:

syedmahtab

See private message.

$85 USD em 10 dias
(34 Avaliações)
4.7

28 freelancers estão ofertando em média $130 para este trabalho

shikhamehta

See private message.

$255 USD in 10 dias
(201 Comentários)
6.9
dominique1

See private message.

$127.5 USD in 10 dias
(296 Comentários)
6.3
unimaxsystems

See private message.

$212.5 USD in 10 dias
(167 Comentários)
5.9
amcsummers

See private message.

$85 USD in 10 dias
(72 Comentários)
5.8
sriframesvw

See private message.

$153 USD in 10 dias
(116 Comentários)
5.7
jal540

See private message.

$148.75 USD in 10 dias
(38 Comentários)
5.6
nicdobresl

See private message.

$187 USD in 10 dias
(15 Comentários)
5.2
Lotusdeveloper

See private message.

$85 USD in 10 dias
(81 Comentários)
5.2
avereshchak

See private message.

$170 USD in 10 dias
(15 Comentários)
4.6
nikitasvw

See private message.

$87.55 USD in 10 dias
(88 Comentários)
4.5
soft1serve

See private message.

$85 USD in 10 dias
(49 Comentários)
4.5
juan1matos

See private message.

$280.5 USD in 10 dias
(19 Comentários)
4.3
smb310570

See private message.

$85 USD in 10 dias
(18 Comentários)
3.7
sbhask2k

See private message.

$85 USD in 10 dias
(17 Comentários)
3.5
ieinfotech

See private message.

$85 USD in 10 dias
(15 Comentários)
3.4
apex8888

See private message.

$85 USD in 10 dias
(2 Comentários)
2.8
prabby81

See private message.

$85 USD in 10 dias
(5 Comentários)
2.5
vw7282474vw

See private message.

$170 USD in 10 dias
(2 Comentários)
1.9
dynamicgk

See private message.

$110.5 USD in 10 dias
(1 Comentário)
1.9
sqlvba

See private message.

$85 USD in 10 dias
(10 Comentários)
1.6