Hi

I am currently using the code below to read the data from worksheet 'data' to a cell in the current active worksheet. This works fine. I now need to change this so that worksheet 'data' is a new, separate spreadsheet. I need to be able to define the folder and the filename of the new workbook (eg file 'support.xlsx' in folder 'C:\temp'.

The current code in use is as follows

' Copy content of 7th colum in 'Support' to colun 'AA' in worksheet T2.

Worksheets("T2").Range("AA" & iRow) = "=VLOOKUP(F" & iRow & ",Support!$A$2:$H$200,7,False)"

Can anyone advise on what changes are needed in the above code please?

Regards