Hi.
I have a workbook with two worksheets on it. In each, there is a list of schools with specific details about each school. The identifier for each school is a Unique Reference Number (URN) which is in column 1 in both of the worksheets.
I would like to combine the two worksheets so that all the data for each school is on one row in just one of the worksheets, rather than split across the two worksheets. I have set the sheets up with exactly the same headers in row 1.
Can anyone help me? If there a formula I can use to match the URN from each sheet and import the data from one sheet to another for that school URN?
I have enclosed a short small file that shows the two worksheets with just a couple of lines of data in each so you can see what I am trying to do (although in my actual sheet there are 20,000 lines of data.
Thanks in advance.
AMANDA
