Vba code to extract data from one sheet to another

Hello all excel experts,

In sheet1 i have row data and sheet2 having output data actually i required a macro which should extract data from sheet1 to sheet2, in sheet2 column A(Name) data should extract from sheet1 from column A(Path) and date
in sheet2 column B(date) data should extract from sheet1 from column A(Path) and Mobile# in sheet2 column C(Mobile#) data should extract from sheet1 from column B(FileName).

Please find the attached sample file

Regards,

Xlhelp7

Could it be that in your exemple sheet 2 the date has to be 3/jan ?

Kind regards
Leo

This takes date from column A, that is different from column F

Please Login or Register  to view this content.

Hi Leo,
Thank you for your reply - much appreciated.
Leo, that is exactly what I am looking for. Works a treat. Thank you!

Regards,

Xlhelp7