I am able to copy and paste the formula only if the cells in the linked sheet are adjacent.
For instance: If the cell values in column B are: ='Sheet2'!J75 ='Sheet2'!J76 ='Sheet2'!J77 An the cell values in column C are: ='Sheet2'!K75 ='Sheet2'!K76 ='Sheet2'!K77
Copy&Paste works.
However if the values are as below, copy and paste results in the same outcome as with the numbers above: in column B: ='Sheet2'!J75 ='Sheet2'!J76 ='Sheet2'!J78 in column C: ='Sheet2'!L75 ='Sheet2'!L76 ='Sheet2'!L78
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel Formulas
For instance I have a table with linked figures divided by 1000.
i.e: in Sheet 1 cell B2 I have: "=('Sheet2'!B2)/1000)"
I want to have "=ROUND(('Sheet2'!B2)/1000,0)"
Is there a way to apply this to multiple cells without manually typing the formula in to each of the hundreds of cells?