Using VBA to copy, and paste in another dynamic cell

[ssu]

Hi!

Hoping someone can help me!

I am trying to write a code for a button. Please see the attached example excel sheet.

I have two sheets; Table1, and Report. Table1 display raw data whilst Report displays a report.

The Table contains a list of training sessions (their code name), their average scores and a recommendation column.

The Report sheet displays individual report for each session. The idea is that the user will be able to type a session code (in cell F1), and the session information will be displayed in this sheet. Now there is also recommendation section in the Report sheet. I would like the user to be able to type in a recommendation in that cell and click on a button, which would then copy that recommendation, into the recommendation column in the Table1 sheet, in the appropriate row for the same session code as referenced in Report sheet's cell F1.

I hope I have explained it alright. I have already some code in the button. But I have a feeling I am approaching this the wrong way and my code really doesn't work.

My VBA knowledge is very basic.

Thank you in advance for everyones help!

S

[alansidman]

Instead of VBA, why not just add a formula, ie. =INDEX(Table1!A:C, (MATCH(Report!F1, Table1!A:A, 0)), 3)