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
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