drums4monty
02-21-2007, 12:17 PM
Hi All
I have a Workbook with 2 worksheets consisting of Coloumn A & B and over 2000 Rows.
Sheet 1 has Reference numbers in the Col A and some data in col B. Worksheet 2 has Reference numbers in col A and a price in col B.
An example of the Reference nums is AB001, AB002, AB003, AB005 etc, as you can see there are gaps in the sequence, Worksheet 2 is the same. Worksheet 1 reference nums starts at say Row 100, this cannot be changed and Worksheet 2 reference nums start at Row 1.
Is it possible to link the 2 worksheets so that the price in col b sheet 2 for the ref AB001 for example, gets placed in col c of sheet 1 for ref AB001 etc?
I know it is as clear as mud but can someone help please?
Regards
Alan
I have a Workbook with 2 worksheets consisting of Coloumn A & B and over 2000 Rows.
Sheet 1 has Reference numbers in the Col A and some data in col B. Worksheet 2 has Reference numbers in col A and a price in col B.
An example of the Reference nums is AB001, AB002, AB003, AB005 etc, as you can see there are gaps in the sequence, Worksheet 2 is the same. Worksheet 1 reference nums starts at say Row 100, this cannot be changed and Worksheet 2 reference nums start at Row 1.
Is it possible to link the 2 worksheets so that the price in col b sheet 2 for the ref AB001 for example, gets placed in col c of sheet 1 for ref AB001 etc?
I know it is as clear as mud but can someone help please?
Regards
Alan