Hey all,

I have to merge data from one sheet into another. It is for a directory website.

I need to import data from one sheet (containing sub-categories) into the other (containing the main categories) All of the cat. and sub-cat. headings are number to correspond with a category.

We need to put the imported data into the cell to the right of the main category. Example Below.

Sheet 1.
1. Banks
2. Bathroom Planners & Furnishers

Sheet 2.
1. Banks
1. Bureaux de Change & Foreign Exchange
1. Foreign Exchange
2. Bathroom Design
2. Bathroom Design & Installation

Merged into :-
1. Banks
1. Banks
1. Bureaux de Change & Foreign Exchange
1. Foreign Exchange
2. Bathroom Planners & Furnishers
2. Bathroom Design

and so on...

Thanks in advance.