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