Hiya,
I need a formula that will sit in a workbook called "John Smith" and look into another workbook called "Data". What it needs to do is look down column A in a sheet called "Raw" and when it finds the name "Abi Peshwar" it needs to show all the data that is next to her name, about 8 cells worth.
So basically in the workbook "Data", we have the data relating to "Abi Peshwar". It takes up a whole row. The thing is, the position of her details may change every day so it could be in row 12 one day and 70 the next day. What I need the "John Smith" workbook to do is look down Column A in the "Raw" sheet in the "Data" workbook, and when it finds "Abi Peshwar", to reproduce the entire row of data back in the "John Smith" workbook
Hope this is clear, if not tell me
I need a formula that will sit in a workbook called "John Smith" and look into another workbook called "Data". What it needs to do is look down column A in a sheet called "Raw" and when it finds the name "Abi Peshwar" it needs to show all the data that is next to her name, about 8 cells worth.
So basically in the workbook "Data", we have the data relating to "Abi Peshwar". It takes up a whole row. The thing is, the position of her details may change every day so it could be in row 12 one day and 70 the next day. What I need the "John Smith" workbook to do is look down Column A in the "Raw" sheet in the "Data" workbook, and when it finds "Abi Peshwar", to reproduce the entire row of data back in the "John Smith" workbook
Hope this is clear, if not tell me