Encerrado

Simple Excel macro to match duplicates and copy to new spreadsheet

I have a spreadsheet with 8 columns that look similar to this:

| A | B | C | D | E | F | G | H |

| QW-123r | Act | 45 | 12-oo | bm-i | asdfasdf | 12.11 | ppp |

| 12R R | Act | 49.63 | bm-i | qwe12 | qwrewqr erer | NO | ooo |

| RRR-23 | In | 12.11 | OPPU | bm-ii | asda 909090 fg | 343.22 | iii |

| 12122-T | Act | 77 | 12122-T | 121 | qwqw122 22 | NO | uuu |

| 22 AA | In | 566.93 | QW22 | 12122-T | vbcnnc fdgg rgfg | NO | yyyy |

| 99 AA | In | 66.96 | Qzz22 | 12122-TTT | vbcnnc yuyu | NO | rrrr |

The macro will check each cell value in column D and match it with the EXACT cell value in column E. If a match is found it will combine the contents of both rows and put it into spreadsheet 2.

So using the the spreadsheet above as example, spreadsheet 2 will look like this:

| A | B | C | D | E | F | G | H |

| 12R R | Act | 49.63 | bm-i | bm-i | asdfasdf | 12.11 | ppp |

| 12122-T | Act | 77 | 12122-T | 12122-T | vbcnnc fdgg rgfg | NO | yyyy |

## 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 GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).

2) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

3) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Employer's environment--Deliverables must be installed by the Worker in ready-to-run condition in the Employer's environment.

b) For all others including desktop software or software the employer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project.

## Platform

excel 2003/2007

Habilidades: PHP, Arquitetura de software, Teste de Software

Ver mais: r architecture, r and r hire, hire act 2010, hire act, excel party hire, excel for hire, spreadsheet 2, simple macro, simple excel, ooo, match, macro e, Hire Excel, combine excel, bm, architecture f, excel combine rows, duplicates excel, excel spreadsheet source code, copy exact, excel spreadsheet check check, 2003 macro 2007, excel macro program, check spreadsheet, php macro

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

ID do Projeto: #2982491

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

shikhamehta

See private message.

$8.5 USD in 2 dias
(182 Comentários)
6.8
quickprogexpert

See private message.

$8.5 USD in 2 dias
(122 Comentários)
6.2
Lotusdeveloper

See private message.

$8.5 USD in 2 dias
(76 Comentários)
5.1
Manid

See private message.

$8.5 USD in 2 dias
(15 Comentários)
4.9
franSystems

See private message.

$6.8 USD in 2 dias
(85 Comentários)
4.8
excelsolution

See private message.

$8.5 USD in 2 dias
(58 Comentários)
4.7
zebiekste

See private message.

$4.25 USD in 2 dias
(10 Comentários)
4.3
ssusavw

See private message.

$7.65 USD in 2 dias
(4 Comentários)
4.5
rcafrompoland

See private message.

$8.5 USD in 2 dias
(18 Comentários)
3.5
jimboyvw

See private message.

$8.5 USD in 2 dias
(11 Comentários)
3.2
ieinfotech

See private message.

$8.5 USD in 2 dias
(13 Comentários)
3.3
darrenmax

See private message.

$4.25 USD in 2 dias
(9 Comentários)
3.0
esalem

See private message.

$8.5 USD in 2 dias
(2 Comentários)
2.9
mrblanke

See private message.

$7.65 USD in 2 dias
(18 Comentários)
2.7
aotechnolog

See private message.

$8.5 USD in 2 dias
(5 Comentários)
2.5
prabby81

See private message.

$8.5 USD in 2 dias
(6 Comentários)
2.4
royedwardsvw

See private message.

$8.5 USD in 2 dias
(2 Comentários)
2.1
cookieburner

See private message.

$8.5 USD in 2 dias
(2 Comentários)
1.8
sqlvba

See private message.

$5.95 USD in 2 dias
(8 Comentários)
1.0
yjh123321

See private message.

$8.5 USD in 2 dias
(3 Comentários)
0.3