Hello all ,

I need to populate certain cells with certain formula but in a bit unusual way..
Let's assume we have two .xlsx files book1.xlsx and book2.xlsx both contain only one datasheet "sheet1" I need to copy formula taking data from book 2 and paste it to book1 but only into certain cells for example:

cell A1 in book1/sheet1 contain formula

=[Book2.xlsx]Sheet1!a1

I need to add it to each 20th cell within book1/sheet1 to increment only by "1" in each cell

A1=[Book2.xlsx]Sheet1!a1
A21=[Book2.xlsx]Sheet1!a2
A41=[Book2.xlsx]Sheet1!a3
etc

Cells in between can not be filled in by any data as the situation will repeat in simmilar way

A2=[Book2.xlsx]Sheet1!b1
A22=[Book2.xlsx]Sheet1!b2
A42=[Book2.xlsx]Sheet1!b3
etc

how this can be achived?

Copy/paste special with options formulas; blank cells; hiding rows or using filters is not an option - I tested it and it failed.

Thank you in advance for your help on this.