Copying data from one worksheet to another

Completed Posted Apr 14, 2012 Paid on delivery
Completed Paid on delivery

I have two worksheets. Each worksheet contains a list of programs and each item in the list can have one or many associated sub-items, these sub-items are listed below and to the right as in the following example.

(Unable to post excel sample here - see additional details sheet)

The second worksheet is similar (many of the items listed are repeated) but the types of data held for each item is different.

I would like some VBA to go through each item in the list and check if this item exists in the second worksheet. If it does I would like all the rows belonging to this item to be cut and inserted back in the first sheet in the row below.

I'm available for any questions. There is a short turn-around on this.

## Deliverables

Sheet 1

<colgroup> <col width="93" span="2" style="width: 70pt;" /></colgroup>

| ZZ23 | |

| | ZZ2301 |

| | UA0301 |

| | UA0302 |

| | FAIRLE05 |

| ZZ24 | |

| | ZZ2401 |

| ZZ45 | |

| | ZZ4501 |

| ZZ48 | |

| | ZZ4801 |

| | GA5VS |

| ZZ61 | |

| | ZZ6101 |

| ZZ62 | |

| | ZZ6201 |

Sheet 2 contains

<colgroup> <col width="64" span="2" style="width: 48pt;" /></colgroup>

| ZZ33 | |

| | SARSITEM |

| | SARSITEM |

| | SARSROOT |

| | SARSROOT |

| ZZ34 | |

| | RPTSOSAR |

| | RPTSOSAR |

| | RPTSROOT |

| | RPTSROOT |

| ZZ61 | |

| | ASRSCOMM |

| | ASRSCOMM |

| ZZ62 | |

| | REPSBILL |

| | REPSBILL |

| | REPSROOT |

| | REPSSPRD |

| | REPSSPRD |

Visual Basic for Apps

Project ID: #2731888

About the project

2 proposals Remote project Active Apr 14, 2012

Awarded to:

sumon355

See private message.

$16 USD in 2 days
(6 Reviews)
2.1

2 freelancers are bidding on average $15 for this job

gatsu58

See private message.

$13 USD in 2 days
(13 Reviews)
2.8