How To Copy A Formula From One Sheet To Another - Select the cell containing the formula that you want to copy. In the clipboard group of the home tab, click. Web = [pulldata2.xlsx]sheet1!a1:b4 if you’re using a dated excel desktop app like excel 2007, excel 2010, etc., you must hit.
In the clipboard group of the home tab, click. Web = [pulldata2.xlsx]sheet1!a1:b4 if you’re using a dated excel desktop app like excel 2007, excel 2010, etc., you must hit. Select the cell containing the formula that you want to copy.