Automating Time Series Calculation For Multiple Companies And Auto Generating Table
I've attached an excel spreadsheet which I need some help with please.
Sheet 2: Company name, revenue in period 1/2/3.... Green part represents the projections/expected figures that come from sheet 1.
Sheet 1: Uses a row in sheet 2 (done per company) and calculates the forecasts (column J and in green). Those figures are put into sheet 2 in the green part.
I need to repeat this per company (I have tonnes of companies but just wrote 3 for example) and need a quicker way of populating the table in sheet 2.
Can someone help me?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Arthurv in forum Excel General
Last Post: 01-06-2012, 10:26 AM
By DerrickRose in forum Excel Charting & Pivots
Last Post: 03-16-2011, 06:58 PM
By lyzias in forum Excel - New Users/Basics
Last Post: 11-22-2009, 04:04 PM
By mitylene in forum Excel General
Last Post: 12-03-2008, 11:54 AM
By Frantic3d in forum Excel General
Last Post: 06-29-2005, 11:05 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1