Copy contents of Col F in last row of Sheet 1 to same location Sheet 2 when text entered in Sheet 1 Col i

[Ironman]

Hi

I need the values in Col F Col G and Col H in the last filled row of sheet 'Training Log' to be copied to the first empty row in Col F Col G and Col I (NOT H) in sheet 'Indoor Bike' only if/when Col I of the last filled row of sheet 'Training Log' contains the text 'Indoor Bike Session'.

For clarity, the tables below both show the value 125 in Col F, 78% in Col G, the value J in Col H and I and the text 'Indoor Bike Session...' in Col I of Training Log.

Training Log

Wed, 29 Sep 2021	OTHER				125	78%	J	Indoor bike session, 60 mins.
						#NUM!

Indoor Bike

Wed, 29 Sep 2021	1:00:00	21.7	13.5	8	125	78%	160	J

Many thanks!

 

[maabadi]

Sorry Paul and maabadi

No Hesitate at all at Board. we learn new method to do with excel when see others post.