locked
Run a formula on Multiple sheets in same workbook RRS feed

  • Question

  • Hi there,

    I have multiple sheets in a workbook and I need to run some specific formulas on each sheet. one of my sheet with the formulas can be accessible via below URL.

    https://drive.google.com/file/d/1G4wTgeV_mnWH4qsiVRGy97JKbOlugej2/view?usp=sharing

    the Formulas are in four Columns AP till AS. And I want to run the same formula in same columns in each sheet.

    Please can someone help me to find the best way to run this on my all sheets. 

    Regards,

    Sara

    Saturday, April 25, 2020 3:56 AM

Answers

  • I got the solution for this. copy and paste the formula and select all sheets and paste the formula in one sheet and all sheets got the formula pasted.

    Thanks - Sara

    • Marked as answer by SaraPhD Tuesday, April 28, 2020 3:33 AM
    Tuesday, April 28, 2020 3:33 AM

All replies

  • Hi,

    According to your shared file, column [AP] (Cutoff Points) seems to be increased by 0.1.
    Is this applied to the last row?

    Regards,

    Ashidacchi -- http://hokusosha.com

    Saturday, April 25, 2020 5:36 AM
  • Column AP (Cutoff Points) will end at 0.9 and it wont go till last row. 

    everything will remain same in columns [AP till AS] and I can just copy and paste that info in each sheet to get results but I have 300 sheets so I am looking for a quick option like a VBA.

    Regards,

    Sara

     
    Saturday, April 25, 2020 8:07 AM
  • I got the solution for this. copy and paste the formula and select all sheets and paste the formula in one sheet and all sheets got the formula pasted.

    Thanks - Sara

    • Marked as answer by SaraPhD Tuesday, April 28, 2020 3:33 AM
    Tuesday, April 28, 2020 3:33 AM