How to auto extract data by Person name and auto generate save in individual file

for some reason I remember your name [TIA]. maybe from another board on the internet? I'm not an expert, but....

to throw data to a new file, you need to use the workbook object and the open method associated with the application object. these should get you started. try it:

workbook object

application object

workbook.open method

Sheet StepB

A3 =[@Person]&Countif($B$3:$B3,$B3) and drag down.


Sheet Amy

A1 = Amy

A3 =IFERROR(INDEX(StepB!Afdrukbereik,MATCH(Amy!$A$1&ROW()-2,StepB!$A$2:$A$23,0),COLUMN()+2),"") and drag across.



If you want to analyse the data you can use a pivot table.

For both solutions see the attached file.

HI oeldere !
I do not know why when i copy the formula to another file, the return value is always the file line in StepB

And what did you expect as return.

Please add manualy the result as example in your excel file (other worksheet).

You don't show your problem in an excel file.

I added the sheet for Jane.

See the attached file.


Edit:

If I change the name on sheet Amy (cell A1) from Amy to Jane you also get the data of Jane.