Hello everyone - this is a very informative site and have found lots of help. I am a bit stuck though with a VBA question
Here is a sample data file
http://www.speedyshare.com/files/229...DataSample.xls
What I am attempting to do is in the sheet Colour Spots, for each row, I want to find the same fishID in the Fish List sheet and then copy paste the river, site and predation for that fishID from Fish List (Sheet) to Colour Spots (sheet).
In other words, I need to fill in site predation and year on the colour spots sheet by finding the proper information on the Fish List sheet.
Thank you in advance
Bookmarks