Creating a master table from a separate input sheet

[WasWodge]

Good evening all. I am attempting to create a new project which is different to anything I have tried before so any help/advise would be much appreciated.
I am trying to create a masterform from a separate input sheet. The input sheet (see "input sheet" attached) when filled in should (when you enter the correct 2 letters in the aisle box) look for the 2 same letters in the aisle row of the master form (See masterform attached) and populate the values into the appropiate rows (Highlighted areas). The added complication is some aisles will have multiple date entries for the same period and need to be listed separately down the rows.
For example if I entered the information below (Obviously on 4 separate days) the masterform should look like the "results" sheet attached

AISLE GH
DATE 1.11.10
LABEL 9
FILL 6
PICK 4
MOVE 5

AISLE LM
DATE 2.11.10
LABEL 5
FILL 6
PICK 5
MOVE 7

AISLE GH
DATE 8.11.10
LABEL 6
FILL 8
PICK 2
MOVE 6

AISLE GH
DATE 12.11.10
LABEL 5
FILL 9
PICK 5
MOVE 9

The reason that I need it on a separate input sheet is this sheet will be e-mailed off via a macro to the warehouse manager daily so he can discuss the results with the relevant team-leader on the same day where as the masterform is for my analytical purposes.
As I said I haven't tackled anything like this before so any ideas would be of benefit.
I hope I have made what I am looking for clear but if not please don't hesitate to ask.

[jaslake]

Hi paul555555

This code is in the attached Input file

Please Login or Register  to view this content.

You'll need to change the underlined line of code. See if it works for you.

John

[WasWodge]

Sorry John I missed your reply. I have given the code a try and it is acting as requested. Thanks for your help and again apologises for the delay in replying

[WasWodge]

Is it possible for a moderator to mark this post as solved as I have lost the "Edit" tab on the original post?