Greetings,
Please could I ask for some help in extracting some data on one sheet and placing into a table on another.
I have attached a spreadsheet which shows what I am trying to accomplish.
When initials entered in a cell, I require excel to recall data from "Data" Sheet under the initials of "AAA" as shown in this example. Excel then lists in the table all the fault numbers and descriptions (fault 1 to 10) on each column before moving to the next row. That have "AAA" in the initials row.
Bookmarks