|I'm not sure I understand your goal. You say that you want to pull data from the Row Data sheet based on the Order Number, but I see more than one piece of data for each category for the same order number. |
For example, on the Raw Data sheet there 29 different Agent Names listed for Order No 1, but only one spot for an Agent Name on the invoice.
If you enter a "1" in the Order No field on the Invoice sheet, which of the 29 different Agent Names do you want to appear?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.