Forum Discussion
Excel formula
Not sure I follow what you want.
You have Actual and Budget columns for each financial period in the Financials sheet. Do you want to extract these and where to?
Have I understood the question?
Peter
- Thanks for reaching out. As you can see there're separate Budgets and Actuals tab in sheet & they're coming from Financials tab only. Budgets and Actuals sheets are created separately to work out the difference between Actuals and Budgets as evident from formulas in "Variance" tab. Now, I don't need to have two separate tabs of Actuals and Budgets & I want to have figures coming directly from Financials tab to Variance tab. Does this makes sense?
Ok - I think I understand what you want and I think you nearly had the solution yourself!
I have added a second sheet (Variance Two) and in the lower half (shaded in yellow) I have extracted the data from the Financials sheet directly. I have only done the FEB data and not the YTD data - but i think the same principles will apply.
hope this helps you !
good luck.
Peter
peteryac60 Thank you for working out on this and yes, you've understood what I need to achieve.
However, I would appreciate any help extended for the second part as well. I've tried to work out for YTD figures but the formula is not working.
