Em Andamento

Excel spreadsheet automatic updates

Please see the attached zip file with a spreadsheet and the folder tree structure for more details.

What I need is a macro that will help me keep the spreadsheet updated with names of new files as they are being added to my directory. Simply put I need to link folder names in the spreadsheet with with appropriate folders in directory and keep the list of files updated with a mouse click.

I need only names without extensions and macro? should be able to discern files already in the spreadsheet from new files added to directory and append the list in red font with names of only new added files.

This is a small project for academic purpose and I thank you for your help!

## Deliverables

In addition, the link to the file should be added in the adjacent column and if file has a comment it should be added to the Comments column.

Habilidades: PHP

Ver mais: tree structure in c, tree red, spreadsheet engineering, folder tree structure, what is macro in excel, structure engineering, php list directory files, excel macro comment, automatic comment, macro spreadsheet, php spreadsheet, php excel macro, excel macro php, tree structure project, excel spreadsheet structure, automatic updates excel spreadsheet, directory tree php, project excel spreadsheet, php directory tree, automatic excel, automatic file, php list directory tree, folder tree excel, excel small, click macro

Acerca do Empregador:
( 1 comentário ) Belgrade, Serbia

ID do Projeto: #2983399

Premiar a:

LogixSmith

See private message.

$17 USD em 14 dias
(54 Avaliações)
6.0

10 freelancers estão ofertando em média $22 para este trabalho

pShankar2

See private message.

$25.5 USD in 14 dias
(409 Comentários)
7.1
shikhamehta

See private message.

$25.5 USD in 14 dias
(211 Comentários)
6.9
Premshanks

See private message.

$24.65 USD in 14 dias
(355 Comentários)
6.5
zenecisvw

See private message.

$25.5 USD in 14 dias
(33 Comentários)
5.0
franSystems

See private message.

$24.65 USD in 14 dias
(98 Comentários)
4.9
vw7384496vw

See private message.

$20.4 USD in 14 dias
(9 Comentários)
4.4
praneeth87

See private message.

$22.1 USD in 14 dias
(15 Comentários)
3.5
esselvw

See private message.

$25.5 USD in 14 dias
(4 Comentários)
2.1
maap0404

See private message.

$17 USD in 14 dias
(0 Comentários)
1.1
tktsoftware

See private message.

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