Macro/VBA Autofill

craigw02

New member
Joined
Sep 20, 2013
Messages
2
Reaction score
0
Points
0
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​
 
Top