transfer a formula with a macro

[luis6777]

Good Morning

I would like to transfer this formula to a macro, any help with this would be myuch apreciated

=IFERROR(INDEX('[Holidays 2014_2015.xlsm]Holidays'!$E$13:$E$300,SMALL(IF(""=OFFSET('[Holidays 2014_2015.xlsm]Holidays'!$O$12,1,MATCH($B$4,'[Holidays 2014_2015.xlsm]Holidays'!$P$12:$NS$12,0),ROWS('[Holidays 2014_2015.xlsm]Holidays'!$E$13:$E$300)), ROW('[Holidays 2014_2015.xlsm]Holidays'!$E$13:$E$300)-ROW('[Holidays 2014_2015.xlsm]Holidays'!$E$13)+1, ""), ROW(A1))),"")

[JOHN H. DAVIS]

Maybe:?

Please Login or Register  to view this content.

[luis6777]

how should i enetr the range, i would like this date inserted in cell B to cell B300

Maybe:?

Please Login or Register  to view this content.

[luis6777]

cell b5 sorry

how should i enetr the range, i would like this date inserted in cell B to cell B300

[JOHN H. DAVIS]

Please Login or Register  to view this content.

[luis6777]

hi

Thanks for this, unfortunatly nothing happen

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Is your workbook Holidays... open?

[luis6777]

yes, but what im looking is for a macro that will give me the same result than the formula not to copy the formula in the cells

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.