Copy and Paste Row from sheet to sheet if Cells Match

[Celticshadow]

Hi Forum

Would forum be kind enough to try and provide a solution for my formula problem in copying a row from one sheet to another dependent on a cell value matching.

I have two sheets one named Btn Fav and the other named Odds Tracker 1, if the cell I2 (containing horse name) in the Btn Fav sheet matches a cell in column B in the odds tracker sheet then I would like to copy the row from A to Q and paste it into the Btn Fav sheet starting at Col P through to Col AF. I have attached an example of what I would like to do as example. Many thanks for looking and hopefully providing a solution.

Regards

 

[Celticshadow]

I think it's because I did not absolute reference the formula at the beginning:



You can either copy the formula above and see if that works once you drag the autofill down, or press F4 on your various cell references to absolute reference the ranges on Odds Tracker 1. The criteria, i2, does not need to be changed. Apologies for the confusion, I thought you were getting an error on everything!

Hi TheMacroNoob

I think that works there is just one cell out of kilter from all 900 rows, I have to pop out just now for a wee bit to get some groceries but will fully check on return and get back to you but hopefully I think thats it. Many thanks and will get back to you.

Regards

 

[TheMacroNoob]

Hi TheMacroNoob

I think that works there is just one cell out of kilter from all 900 rows, I have to pop out just now for a wee bit to get some groceries but will fully check on return and get back to you but hopefully I think thats it. Many thanks and will get back to you.

Regards

Okay, that is good news! Apologies for not noticing the problem earlier, could have saved some time.

 

[Celticshadow]

Hi TheMacroNoob

Many thanks for your help your solution works a treat and I really do appreciate you giving up your time and sharing your knowledge. You are a credit to forum and yourself, absolutely topnotch.

Regards