In sheet 1, i have a bunch of cells that have one word in them that begin in A2.
I would like to create a Macros that creates sheets and names them with the cell in column A and also pastes the cell into the respective sheet in A1. I would like it to write the word "PX_Volume" in B1 and insert the following formulae in A2 for all respective sheets "=BDH(A1,B1,"-1ay","","cols=2;rows=252")".
Bookmarks