*Worksheet 1*

A1 = Order00001

A2 = Order00001

and so forth.

The second work book contains information which relates to a certain order, but does not yet have an order number set. This information is stored in rows i.e.

*Worksheet 2*

Row 1 = Unassigned order 1

Row 2 = Unassigned order 2

and so forth.

These unassigned orders will however, at a later date, be given one of the unique order numbers from worksheet1 . I need a forumla which, when an order number is given to a particular unassigned order, copies the information from that particular unassigned orders into the columns of the same order number in worksheet 1. For example:

*If*data from worksheet2 columns A2:A5 are copied to the same columns next to the relevant order number row in worksheet1

**worksheet2!**A1 = "[Unique Order Number]"I understand that this may be confusing so please reply if you need clarification.