Hello fellas,
I managed to make a macro work at the startup of the sheet but the formulas in the sheet do not work because they consist datas from the seperate sheet which gets created by the macro that runs in the startup just because macro works after the sheet looks for the references in the formula hence give #REF! errors.Any idea how i can hold my formulas to calculate till macro runs first at the startup of the sheet.Thanks in advance