Hi there,

I am looking for a marco to look in cell L20 of my spreadsheet as this is where all my info starts and if this is not blank fill it with this actual formula

=IF(L20="","",REPLACE(CELL("filename",L20),1,FIND("]",CELL("filename",L20)),""))

If the cell is blank then leave blank and stop when the figures in column L ends.

Need this to happen in all active tabs within the workbook, as I could have 5 tabs or 35 tabs depending on info received.

Thanks

Craig