Please Help, New Cattle Management System, Linking Information On Different Sheets

[Harrywatson]

[TABLE="width: 753"]
<tbody>[TR]
[TD] A
1590
[/TD]
[TD] B
11/05/2011
[/TD]
[TD] C
UK51197810242517032013MSMX 01
[/TD]
[TD] D
UK511978
[/TD]
[TD] E
102425
[/TD]
[TD] F
17-03-2013
[/TD]
[TD]G
M
[/TD]
[TD] H
SMX
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]1591
[/TD]
[TD]18/08/2011
[/TD]
[TD]UK52197850242918032013MSMX 01
[/TD]
[TD]UK521978
[/TD]
[TD]502429
[/TD]
[TD]18-03-2013
[/TD]
[TD]M
[/TD]
[TD]SMX
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]1592
[/TD]
[TD]17/02/2011
[/TD]
[TD]UK53197870243119032013MAAX 01
[/TD]
[TD]UK531978
[/TD]
[TD]702431
[/TD]
[TD]19-03-2013
[/TD]
[TD]M
[/TD]
[TD]AAX
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]1593
[/TD]
[TD]17/06/2011
[/TD]
[TD]UK54197850243622032013MSMX 01
[/TD]
[TD]UK541978
[/TD]
[TD]502436
[/TD]
[TD]22-03-2013
[/TD]
[TD]M
[/TD]
[TD]SMX
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

On Sheet One Named 'CATTLE ON' I have information about cattle set up like this.
Column A: The animals indivdual number. These carry on down the sheet with the odd break in pattern. eg. 1100 to 1600

Column B: The date when the animal comes to the farm

Column C: The number which is scanned from a barcode

Column D: Part of the animals registered number (from barcode)
Column E: Another part of the animals registered number(from barcode)

Column F: Date of birth (from barcode)

Column G:Sex of animal(from barcode)

Column H:Breed of animal(from barcode)


On Sheet 2 which is named 'CATTLE OFF' I would like to be able to put the animals individual number in the column A and then automatically the information from columns B,C,D,E,F,G and H on Sheet One 'CATTLE ON' would be inserted into Columns B,C,D,E,F,G and H.

Eg. When I insert the number 1592-The rest of the relative information (Below) would then be inserted into the other columns that follow.
Help would be greatly appreciated, Thankyou
[TABLE="width: 753"]

<tbody>
[TR]
[TD]17/02/2011
[/TD]
[TD]UK53197870243119032013MAAX 01
[/TD]
[TD]UK531978
[/TD]
[TD]702431
[/TD]
[TD]19-03-2013
[/TD]
[TD]M
[/TD]
[TD]AAX
[/TD]
[TD]

[/TD]
[/TR]

</tbody>
[/TABLE]

 

[Eric Golf]

Hi,

Presuming titles in row 1 and you want the column order the same, then in B2 in sheet CATTLE OFF:-

=VLOOKUP($A2,'CATTLE ON'!$A:$H,COLUMN(),0)

fill right to H2 & down as far as required.

Hope this helps

Eric

 

[Harrywatson]

Hi,

Presuming titles in row 1 and you want the column order the same, then in B2 in sheet CATTLE OFF:-

=VLOOKUP($A2,'CATTLE ON'!$A:$H,COLUMN(),0)

fill right to H2 & down as far as required.

Hope this helps

Eric

Thanks a lot Eric. This works perfectly! What would be ideal is that when an animals number that had been submitted in the CATTLE OFF page eg. 1653
Then in the CATTLE ON page the number 1653 would then be highlighted a colour. Ideally the number, and all of its contents/information: Columns A:H

 

[Harrywatson]

Or just the number? Is any of this possible, Thanks a lot