Copy contents of table with todays date

[Gazphillips]

I am looking for a code that can auto copy certain cells across to another sheet.

On tab " Front Sheet Signature " I want the table to auto populate any information we input on the "Investigations" tab ( The purple columns on the investigations tab are what we are trying to get copied over automatically ) that has the date we specify in L2 on the front sheet.

The above is the Front Sheet
Below is the Investigations Tab

Is this easily done, as I am finding it fairly difficult - Any help would be massively apricated

Kind Regards


EDIT:
Actually, to make it easier - We just need column J "Investigations" into column B "Front Sheet " that has the date we specify in L2 on the Front sheet

 

[awoohaw]

Welcome to the Mr. Excel forum.
This forum has a tool which allows you to help the forum help you. It is called xl2bb add in (link below). It allows you to paste a mini worksheet of your data and formulas. And if that doesn't work for you, then you have the ability to paste your data in a table (be sure to label column and row). Posting images does not help the forum help you. The forum needs to completely recreate your scenario and that takes time, and worse they can make errors in data entry or assumptions.

Thanks in advance,