Forum Discussion

Herman86's avatar
Herman86
Copper Contributor
Mar 24, 2020

Set a cell equal to the formula in another cell and not its value

Hi, I have the following issue: I have a file with numerous sheets with the same data columns (different data). The final column is a formula column using the actual sheet's data for the calculatio...
excel
Formulas and Functions
ExcelExciting's avatar
ExcelExciting
MVP
Mar 24, 2020

Hi Herman86 

 

to apply formula in all sheet, select the sheet which you wish to Apply the formula and write your formula.. 

You should try Excel Tables that will automatically expand the range of your data.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

  • Herman86's avatar
    Herman86
    Copper Contributor
    Mar 24, 2020

    Hi ExcelExciting, 

    I first thought you misread my question, but this does solve my problem.

    Thank you!

    Regards

    Herman

    • ExcelExciting's avatar
      ExcelExciting
      MVP
      Mar 24, 2020

      Herman86 Glad to hear your query is resolved don't forget mark as Official Answer to close the post 

       

      Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

      If you find the above solution resolved your query don't forget mark as Official Answer.

Resources