Forum Discussion
Excel formula
Hi,
I've attached the excel sheet wherein there are three primary worksheet "Financials", "Budgets" and "Actuals" and one main sheet "Variance". The Financial sheet contains Actuals and Budgets for the year and Variance sheet contains comparative monthly and YTD variances between actuals and budgets. The variance sheet updates figures when month is entered in cell C4.
At present, I've to make two different sheets "Actuals" and "Budgets" out of Financials sheet as I don't know proper solution or function to update figures directly from Financials sheet without creating additional 2 sheets. I need help to derive figures directly from Financials tab without making those 2 extra sheets.
15 Replies
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
